Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N56461Woody Aaron Michael · Cypress, TXBuilt 1973 · S/N 28R-73-35438 N5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442 N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635 N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003 N56477Divelbiss Donald S · Fredericktown, OHBuilt 1973 · S/N 327300063 N5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443 N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804 N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639 N56488Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1973 · S/N 28R-73-35444 N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807 N56496Ics Air LLC · Saint James, MNBuilt 1973 · S/N 28-7310167 N5649DNielsen Joseph M · Fresno, CAS/N 287515430 N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445 N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808 N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406 N564KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843880 N564PUPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 2842169 N56506Nassour Aviation Inc · Ellisville, MSBuilt 1973 · S/N 28-73-25641 N5650USkyways Group LLC · Greensboro, NCBuilt 1969 · S/N 28-26446 N56510Brocon Aviation LLC · West Des Moines, IABuilt 1973 · S/N 327340187 N5651VBecker Florian Alexander · Fort Lauderdale, FLBuilt 1977 · S/N 32R-7780350 N5651WHouk David A Jr · Norton, OHS/N 28-834 N56521Hawkes Tyler · Rexburg, IDBuilt 1973 · S/N 28-73-25647 N56524Registration Pending · West Palm Beach, FLRegistration pendingS/N 28-73-25650 N56525Sadi Susan Salimi · Arlington, TXS/N 28-7325651 N56527Kappel Kyle D · Crossville, TNBuilt 1973 · S/N 32-73-40189 N56536Hurlbut Gary A · Seattle, WABuilt 1973 · S/N 28-7325653 N5653UMcclelland Robert C · La Veta, COBuilt 1969 · S/N 28-26449 N5653VFields Shannon L · Huntsville, ALS/N 32R-7780351 N5653WCrump William J · Williamstown, NJFirst renewal noticeBuilt 1962 · S/N 28-840 N5654VHodges Tandi R · The Woodlands, TXBuilt 1977 · S/N 28-7716190 N5654WHaymes Will · Knoxville, TNBuilt 1962 · S/N 28-815 N5655Phillips Mark E · Williamsville, ILS/N 28-3720 N56558Onlyfly LLC · Deltona, FLS/N 28-7425004 N56559Waggoner Gregory · Woodward, OKBuilt 1973 · S/N 28-7405017 N5656WBennett Steven D · Durham, NCS/N 28-821 N56573Knuth Matthew · Waupaca, WIBuilt 1973 · S/N 28-7405019 N56578Somerset Air Service Inc · Bedminster, NJBuilt 1973 · S/N 28-7325661 N5657WMacdonald Kenneth A · Willow, AKBuilt 1962 · S/N 28-822 N56580Young Robert L Trustee · Ashland, OHBuilt 1973 · S/N 287325662 N56584Pathfinder Air Inc · Troy, MIBuilt 1973 · S/N 28-7410012 N5658UTully James W · Clarksville, TNBuilt 1969 · S/N 28-26454 N5658VN5658v Aviation LLC · Huntsville, TXBuilt 1977 · S/N 28R-7737067 N56591Williams Anthony S · Miramar, FLBuilt 1973 · S/N 28-7325664 N56592Clw Aviation LLC · Springville, ALBuilt 1973 · S/N 28-7325665 N56596Gutowski Michael H · Westfield, MABuilt 1973 · S/N 28-7405021 N56598Avalos Alberto Hernandez Jr · Detroit, MIBuilt 1973 · S/N 28R-7435016 N5659WLeon James M · Frankfort, ILBuilt 1962 · S/N 28-826 N565LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881905 N565TFAir Therapy LLC · Chapel Hill, NCBuilt 2022 · S/N 2881565

Back to AD 87-08-08 R3