Skip to content

Registered aircraft · 54,019

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N22069Frank Merle R Trustee · Wasilla, AKBuilt 1982 · S/N 18504368 N2206CPatton Mark A · Aurora, COBuilt 1953 · S/N 30506 N2206RKahonees Travel Services LLC · Pleasanton, TXBuilt 1968 · S/N T210-0356 N2206YSanders Andrew · Livingston, MTBuilt 1967 · S/N 17700006 N22070Mcmullen Christopher · Holt, MOBuilt 1967 · S/N 15068043 N22076Glacier Flight Training LLC · Whitefish, MTBuilt 1967 · S/N 15068047 N22078Line Electric Company LLC · Lake City, FLBuilt 1967 · S/N 15068049 N2207CDurden Dewitt D · Spanish Fort, ALBuilt 1953 · S/N 30507 N2207DGrosshandler Kevin · Palmer, AKBuilt 1952 · S/N 20359 N2207ETeton Leasing LLC · Pocatello, IDBuilt 1978 · S/N 17271186 N2207GTatro Christopher A · Madras, ORBuilt 1958 · S/N 51507 N2207JCoolidge Marvin L · Newberg, ORBuilt 1966 · S/N 15065407 N2208Gibson Kevin T · Orange, VABuilt 1956 · S/N 29503 N22080Sale Reported · Las Vegas, NVSale reportedS/N 17264053 N22085Chandler Judd S · Corryton, TNBuilt 1967 · S/N 15068055 N22086Jackson Allan D · Wetumpka, ALS/N 15068056 N2208GAskerli Auto LLC · Kalispell, MTBuilt 1958 · S/N 51508 N22090Aces Aviation LLC · Buffdale, UTBuilt 1967 · S/N 15068058 N2209DMaas Michael H · Mendota, ILBuilt 1952 · S/N 20361 N2209EIngersoll George P · Lakewood, COBuilt 1978 · S/N 17271188 N2209RPilotsgirl LLC · Goldsboro, NCBuilt 1968 · S/N T210-0359 N220EPLeyva Jose Luis · New Smyrna Beach, FLBuilt 1985 · S/N 172-76484 N220FBCulbertson William Theodore · Helena, MTBuilt 1967 · S/N R172-0221 N220JAHogan Field Hangars LLC · Fairfield, OHBuilt 1984 · S/N 172-76157 N220MEBoyle Flying Service Inc · Boyle, MSBuilt 1967 · S/N U206-0797 N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593 N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N220WSClark Alan R · Tucson, AZBuilt 1978 · S/N R18200260 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N22102Registration Pending · Metairie, LARegistration pendingS/N 15068063 N22106Andreu Kenneth J · Valhalla, NYS/N 15068064 N2210DSample Richard F · Ellensburg, WAS/N 20362 N2210JAmes Stephen A · Scottsdale, AZBuilt 1966 · S/N 15065410 N2210RCarroll James K · Paso Robles, CAS/N T210-0360 N22110Schmitt Rudy · Brookshire, TXS/N 15068066 N22115Cummins Michael P · University Park, MDBuilt 1967 · S/N 15068069 N2211DKuhn Michael D · Knapp, WIBuilt 1952 · S/N 20363 N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511 N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N22123Hughes James H · Northlake, TXBuilt 1967 · S/N 15068074 N22128Sale Reported · Royal, ARSale reported, pending cancellationBuilt 1967 · S/N 15068077 N22129Morrison Dwayne L · Columbia, SCBuilt 1967 · S/N 15068078 N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516 N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012 N22130Kall Joseph F · Bozeman, MTBuilt 1967 · S/N 15068079 N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074

Back to AD 87-20-03 R2