Registered aircraft · 108,433

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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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.

N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812 N224KKN224kk LLC · Newport Beach, CABuilt 2016 · S/N 1168-2016 N224KRJds Holdings LLC · Oneida, TNBuilt 2002 · S/N 0179 N224LJJets To Helis LLC DBA · Chandler, AZBuilt 2022 · S/N 4872 N224LRCamp95 Enterprises LLC · Wheeling, WVBuilt 2002 · S/N 0155 N224MAAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8613 N224MGBuell Travis · Harper, TXBuilt 2001 · S/N 3276 N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089 N224MJGlover William Scott · Mount Pleasant, TXS/N 1-064 N224MMYoung David A · Bedford, TXBuilt 1972 · S/N 28-7225291 N224NDGood Flight Aviation LLC · Stockton, CABuilt 2001 · S/N 2842112 N224NXNexair Avionics LLC · Plymouth, MABuilt 2002 · S/N 0170 N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016 N224PLKeeney Charles E · Ash Grove, MOBuilt 2010 · S/N 73209 N224RBR44 LLC · Allentown, PABuilt 2006 · S/N 11408 N224RGBonanza Aircraft Inc Trustee · Cheyenne, WYBuilt 2009 · S/N E-3894 N224RVSchilthelm John A · Lake Geneva, WIBuilt 1999 · S/N 1779 N224RWNomad Air LLC · North Bend, WABuilt 2005 · S/N 1595 N224RXFlyteone Production & Maintenance LLC · Clearwater, FLBuilt 2017 · S/N SFG014 N224SSmith Darrell E · Duncan, OKBuilt 1965 · S/N TC-892 N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152 N224SJPrestige Aircraft LLC · Madison, WIBuilt 2003 · S/N 0705 N224SMMueller Terry L · Thomson, GABuilt 2000 · S/N 001 N224STB & G Aviation Enterprises LLC · Lilburn, GABuilt 2004 · S/N 0882 N224SYMrc1 LLC · Bernie, MOBuilt 2002 · S/N 0184 N224TVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2338 N224TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020126 N224TGPlaneview LLC · Fountain Hills, AZBuilt 2005 · S/N 1570 N224TJJennings Herschel Todd · Stone Mountain, GABuilt 1993 · S/N 5283 N224TNPoe Edgar A · Chandler, AZBuilt 2007 · S/N 60301 N224TPSale Reported · Carson City, NVSale reported, pending cancellationBuilt 1955 · S/N 22-2950 N224TRRasmuson Ronald F · Clancy, MTBuilt 2008 · S/N 25335 N224UKNapier Timothy N · Townsend, TNBuilt 1992 · S/N 2213 N224VUp And Up Aviation LLC · Magnolia, TXS/N 28-7916402 N224VRConcho Aviation LLC · Sterling City, TXBuilt 2000 · S/N 3038 N224VSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12893 N224VWMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881533 N2250BBill Frank J · Enfield, CTBuilt 1978 · S/N 28-7916122 N2250EDover Afb Aero Club · Dover Afb, DEBuilt 1978 · S/N 17271205 N2250KKaemmerling Mirna C · White Oak, TXBuilt 1978 · S/N 28-7990240 N2251GValentine Terence S · Glennallen, AKBuilt 1958 · S/N 51551 N2251TGardner Bryan T · Rancho Cucamonga, CABuilt 1977 · S/N R18200007 N2252CMickey Donald J · Albuquerque, NMBuilt 1953 · S/N 30552 N2252FAdh Enterprises Inc · Sherman, ILBuilt 1966 · S/N 310L-0052 N2252GRutter Eric R · Anchorage, AKBuilt 1958 · S/N 51552 N2252LEaton David B Jr · Leicester, MABuilt 1977 · S/N M-1897 N2252RStout Walt · White Hills, AZBuilt 1968 · S/N T210-0402 N2252SSpider Lips Aviation LLC · Fischer, TXBuilt 1976 · S/N 21061196 N2252TRegistration Pending · Hayward, WIRegistration pending, pending cancellationBuilt 1968 · S/N 185-1410 N2252USkylake Adventures LLC · Geneva, OHS/N 411

Back to AD 2007-04-19 R1