Skip to content

Registered aircraft · 54,015

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.

N6362BSimplot Don J · Boise, IDFirst renewal noticeS/N 34262 N6362EYoungblood Harley O III · Vancouver, WABuilt 1959 · S/N 46462 N6362FCabral Nicholas · Oldsmar, FLBuilt 1966 · S/N 337-0362 N6362SMott Charles A Jr · Chesapeake, VABuilt 1967 · S/N 15067162 N63632Prestige Air Charter Inc · Sandston, VABuilt 1975 · S/N 15077442 N63637Oclair Justin B · New Canada, MES/N 15077445 N63638Skywagon LLC · Wilmington, DES/N 18052858 N6363AWong Adrian Trustee · San Francisco, CABuilt 1956 · S/N 33163 N6363EHanson Douglas L · Montpelier, VTBuilt 1959 · S/N 46463 N6363GGillis Timothy L · Kenai, AKBuilt 1970 · S/N 15071863 N6363KKnoblock Stephen A · Acworth, GABuilt 1976 · S/N R1722041 N6363SSnell Matthew L · Ackerly, TXS/N 15067163 N63641Cole Warren G · Watkinsville, GABuilt 1975 · S/N 15077448 N63645Greene Roswell J · Punta Gorda, FLBuilt 1975 · S/N 15077451 N63646Reed Phillip · Lanesboro, MNS/N 15077452 N63647Appalachian Wings LLC · Ellijay, GABuilt 1975 · S/N 15077453 N6364BKgnf LLC · Grenada, MSBuilt 1978 · S/N 21062750 N6364CSukhakarta Rentals LLC · Cedar Park, TXBuilt 1980 · S/N 21063875 N6364DSuburban Aircraft Leasing And Sales LLC · Sylvania, OHBuilt 1979 · S/N 17272750 N6364GCarlstadt William A · South Bound Brook, NJBuilt 1970 · S/N 15071864 N63650Crain Charles E III · San Antonio, TXBuilt 1975 · S/N 15077455 N63651Agricola Joseph D · Brooksville, FLBuilt 1975 · S/N 15077456 N63652Tyndall Darryl K · Deep Run, NCFirst renewal noticeBuilt 1975 · S/N 15077457 N63653Coker Steve L Jr · Tyler, TXBuilt 1975 · S/N 15077458 N63655Van Houten Ronald G · Kalamazoo, MIBuilt 1975 · S/N 15077459 N63657French Chris · Anchorage, AKBuilt 1975 · S/N 15077460 N63659Droege Robert Michael · Saratoga Springs, NYBuilt 1981 · S/N 17275463 N6365BKnopp Steven L · Camano Island, WABuilt 1957 · S/N 34265 N6365FRindo David J · Lowell, MABuilt 1979 · S/N 17273203 N6365GN6365g LLC · Buckeye, AZBuilt 1970 · S/N 15071865 N6365KSchlueter Wayne J · Andover, KSBuilt 1975 · S/N 15077666 N6365UPino Carlos R · Santa Fe, NMBuilt 1985 · S/N 21064944 N63662Gessert Adam K · Gilbert, AZS/N 15077463 N63663Lake Aviation LLC · Murfreesboro, TNBuilt 1981 · S/N 17275465 N63664Cabrera Ramon F · Guttenberg, NJS/N 15077465 N63665101 Flight LLC · Waterford, MIBuilt 1975 · S/N 15077466 N6366AHunsaker Travis J · Salem, ORBuilt 1956 · S/N 33166 N6366FDerose Joseph F · Salt Springs, FLBuilt 1979 · S/N 17273204 N6366GTownson Charlotte K · Cisco, TXBuilt 1970 · S/N 15071866 N6366KCastano Jose R · Sleepy Hollow, NYBuilt 1975 · S/N 15077667 N63670Uflyorlando Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 15077471 N63671N63671 LLC · Austin, TXBuilt 1975 · S/N 15077472 N63677Weir Ryan Lee · Buckley, WABuilt 1975 · S/N 15077477 N63679Goldman Jacob · Bend, ORBuilt 1975 · S/N 15077479 N6367AFritz Mathew L · Boise, IDBuilt 1956 · S/N 33167 N6367BSmart John H · Chugiak, AKBuilt 1957 · S/N 34267 N6367KPethes Ted · Las Vegas, NVS/N 15077668 N6367QCc Aviation Inc · Tracy, CABuilt 1981 · S/N 15285236 N6367SLogtime Flight LLC · Lancaster, TXBuilt 1967 · S/N 15067167 N63681American Patrols Inc · Midland, TXBuilt 1981 · S/N 17275467

Back to AD 87-20-03 R2