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.

N5VTEmaaduddin Mohammed · Yonkers, NYBuilt 1967 · S/N 28-23176 N5YPMo'S Ventures LLC · Lakeside, CABuilt 1974 · S/N 327440067 N6000TO'Neill Christopher M · Newark, OHBuilt 1973 · S/N 28-7310115 N6000WPort Townsend Aero Museum · Port Townsend, WABuilt 1963 · S/N 28-20000 N6002WPeppas George D Jr · Fort Wayne, INS/N 28-20002 N6003USoarin Seven Aviation LLC · Morton, ILBuilt 1970 · S/N 28-26809 N6003WCarmon Walter A · Highland, NYS/N 28-20003 N6004HEngin Aires Aero Club · Savoy, ILS/N 28-7890199 N6005UHaney William R · Pontotoc, MSBuilt 1970 · S/N 28-26906 N6006UFaith Peter E · St Charles, ILS/N 28-26907 N6006WGreen William A · Memphis, TNBuilt 1964 · S/N 28-20006 N6007USteele Tucker L · The Colony, TXFirst renewal noticeBuilt 1970 · S/N 28-26817 N6007WMoore Merritt · Mcarthur, CAS/N 28-20007 N6008HSwartz Selden H Jr · Jacksonville, ORBuilt 1977 · S/N 28R-7837047 N6009WLowman Jeffrey L · Clarksburg, WVBuilt 1964 · S/N 28-20009 N600AABrauer Jason R · Winnebago, ILBuilt 1968 · S/N 28-25102 N600AVMountain Top Aviation Inc · Ebensburg, PABuilt 1978 · S/N 28-7916229 N600CJPoly Plastics Inc · Owatonna, MNBuilt 1978 · S/N 32R-7885050 N600HJRavotti Air LLC · Leechburg, PABuilt 1978 · S/N 28-7990004 N600JGWiltcher Christopher Alex · Gallatin, TNBuilt 1969 · S/N 32-40726 N600JLMinisterio Internacional Gracia Y Poder Inc · Houston, TXBuilt 1973 · S/N 32-7400010 N600PFEastern Aviation Corp · Whitestone, NYBuilt 1977 · S/N 28-7816109 N6011FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020090 N6014WLeaders Bob O · Clear Lake, MNBuilt 1964 · S/N 28-20014 N6015FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020091 N6017WKarg James R · Paradise, TXBuilt 1964 · S/N 28-20017 N6018FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020092 N601BSThird Coast Aircraft LLC · Mobile, ALBuilt 1970 · S/N 28R-35798 N601EAExecutive Air Transport Inc · Norton Shores, MIBuilt 1978 · S/N 28-7916124 N601FTSanson Paul H · Deland, FLBuilt 1989 · S/N 2841195 N601TGKenmore Crew Leasing Inc · Bellingham, WAS/N 28R-7235214 N6020WBritton Jeffrey A · Accident, MDBuilt 1964 · S/N 28-20020 N6021WA&C Aviation LLC · Lawrenceville, GABuilt 1964 · S/N 28-20021 N6024WWhite Pelican LLC · Union City, TNBuilt 1964 · S/N 28-20024 N6025WSocal Flights LLC · Simi Valley, CAS/N 28-20025 N6029WWalsh Robert D · Somerset, CABuilt 1964 · S/N 28-20029 N602DTFollow Your Bliss LLC · Woodbury, MNBuilt 1980 · S/N 28-8011118 N602FLRoberts David R · West Newton, MABuilt 1971 · S/N 28-7125476 N602FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716056 N602PCJ & P Aviation LLC · Plymouth, MABuilt 1979 · S/N 28-7990581 N602SCSale Reported · Marble Falls, TXSale reportedBuilt 2002 · S/N 3257286 N6030FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020093 N6031FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020094 N6033WGreen Apple Solutions LLC · Durham, NCBuilt 1964 · S/N 28-20033 N6034WMiner Timothy Scott · Hartford, ALBuilt 1964 · S/N 28-20034 N6035FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020095 N6036WEdwards Darrell R · Artesia, NMBuilt 1964 · S/N 28-20036 N603APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843769 N603BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020286 N603CEGulf Coast Premier Aviation LLC · Cape Coral, FLBuilt 2023 · S/N 2881660

Back to AD 87-08-08 R3