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.

N738FHNickel Bush Enterprises LLC · Walla Walla, WABuilt 1979 · S/N R18200920 N738FMFinefield James P · Cary, ILBuilt 1977 · S/N 17269943 N738FYVero Technical Support Inc · Pensacola, FLBuilt 1977 · S/N 17269954 N738FZSun Aviation Inc · Cambridge, MNBuilt 1977 · S/N 17269955 N738GACone Ira M · Frazier Park, CABuilt 1977 · S/N 17269956 N738GBFlying Grass Hopper LLC · Barrington, ILBuilt 1977 · S/N 17269957 N738GEPs Aviation Inc · Granada, MNBuilt 1977 · S/N 17269960 N738GJJlinn Aviation Inc · Quinlan, TXBuilt 1977 · S/N 17269964 N738GMNesher Aviation II LLC · Jacksonville, FLBuilt 1977 · S/N 17269966 N738GSWestern Edge Aviation LLC · Dickinson, NDBuilt 1977 · S/N 17269971 N738GVMolnar Raymond Jr · Ashford, CTBuilt 1977 · S/N 17269974 N738GWJensen Rodney H · Sandy, UTS/N 17269975 N738GZPickard Steve H DBA · Louisville, GABuilt 1977 · S/N 17269978 N738HATerrill Mary C · Bloomingdale, ILBuilt 1977 · S/N 17269979 N738HCPlane And Simple Holdings LLC · Saint Petersburg, FLBuilt 1979 · S/N R18200927 N738HDG&M Aircraft Inc · Wheat Ridge, COBuilt 1977 · S/N 17269982 N738HHPitre David E · Santa Fe, TXBuilt 1977 · S/N 17269986 N738HJMcnamara Patrick J · Marstons Mills, MABuilt 1977 · S/N 17269987 N738HKEini Yaakov · Valley Glen, CABuilt 1977 · S/N 17269988 N738HPNidiffer Alan W · Brookings, ORBuilt 1977 · S/N 17269992 N738HSFlycarolina LLC · Concord, NCBuilt 1977 · S/N 17269995 N738HTRucci Daniel C · Saint Cloud, FLBuilt 1977 · S/N 17269996 N738HXRick Aviation Inc · Newport News, VABuilt 1977 · S/N 17270000 N738JDClover Management Systems Inc · Sanford, FLBuilt 1977 · S/N 17270006 N738JFCopperhead Environmental Consulting Inc · Paint Lick, KYBuilt 1977 · S/N 17270008 N738JGSullivan James F · Hamilton, ILBuilt 1977 · S/N 17270009 N738JJGreat Lakes Aviation Inc · Batavia, NYBuilt 1977 · S/N 17270011 N738JPHaskins Robert A · Salinas, CABuilt 1977 · S/N 17270016 N738JRRutkosky John J DBA · Palm Coast, FLS/N 33701878 N738JSWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17270019 N738JTNorthwoods Air LLC · Orono, MEBuilt 1977 · S/N 17270020 N738JULlano Masonry LLC · Lubbock, TXBuilt 1977 · S/N 17270021 N738JWAllen Stephen R · Ventura, CABuilt 1977 · S/N 17270023 N738JXSuperior Flying Services LLC · Superior, WIBuilt 1977 · S/N 17270024 N738JZRegistration Pending · Washington, UTRegistration pendingBuilt 1979 · S/N R18200935 N738KAFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17270027 N738KCCarter Flygare Inc · Sacramento, CABuilt 1977 · S/N 17270029 N738KFShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 17270032 N738KG738 Kilo Golf LLC · Southern Shores, NCBuilt 1977 · S/N 17270033 N738KJFly Compton Aeronautical Education Foundation · Compton, CAS/N 17270035 N738KKSpradley Amanda · Greenwood, SCFirst renewal noticeBuilt 1977 · S/N 17270036 N738KPJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1977 · S/N 17270040 N738KQYeomans James S · Harvey Cedars, NJBuilt 1977 · S/N 17270041 N738KTGetaway Aviation LLC · Spring Lake, MIS/N 17270044 N738KUBoehmlehner Steven A · Rosholt, SDBuilt 1977 · S/N 17270045 N738KWAvetrani Jose A · Miami, FLBuilt 1977 · S/N 17270047 N738LCCruise Flight Academy Inc · Dalton, GABuilt 1977 · S/N 17270053 N738LGSchultz Leesa · Mesquite, NVS/N 17270057 N738LHLh Enterprise LLC · Eads, TNS/N 17270058 N738LMBlack Bear Aviation LLC · Scottsdale, AZBuilt 1977 · S/N 17270062

Back to AD 87-20-03 R2