Registered aircraft · 47,142

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

N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277 N1292RHudson Mitchell C · Erie, COBuilt 1966 · S/N 4324 N1293CTexas Blue Skies Aviation LLC · Canyon Lake, TXBuilt 2003 · S/N 0565 N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860 N1293VEgmond Aircraft LLC · Lewes, DES/N 310Q1038 N1294PBagdasarian Walter DBA · El Cajon, CABuilt 2006 · S/N 41660 N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861 N1295JN1295j Corp Trustee · Wilmington, DEBuilt 2006 · S/N 41641 N1296AN1296a LLC · Asheville, NCBuilt 1969 · S/N D-9030 N1296FWalker Brandon · Anchorage, AKBuilt 1975 · S/N 18502816 N1296GAir Dogs LLC · Watford City, NDBuilt 1976 · S/N 310R0698 N1297EWood Paul Richard · Cumming, GABuilt 2008 · S/N 411097 N1297GPilot Mountain Aviation LLC · Marietta, OHBuilt 1974 · S/N 310R0003 N1297LOklahoma Cirrus LLC · Mclean, VABuilt 2003 · S/N 0713 N1297SAlpine Skylane LLC · Alpine, WYS/N 18264864 N1298GMango Tango Air LLC · Cantonment, FLBuilt 2007 · S/N 42533 N1298MRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 18264280 N1298RSouthern Utah University · Cedar City, UTBuilt 1972 · S/N 30479 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N1298ZShaw Aviation LLC · Greenleaf, IDBuilt 1961 · S/N D-6738 N1299HB&C Aviation LLC · Helena, MTBuilt 2008 · S/N 411099 N1299KOrange And Black LLC · Lewes, DEBuilt 2008 · S/N 411062 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561 N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309 N129BCAviation Innovations LLC · Dover, DES/N 0818 N129BETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2019 · S/N E-4129 N129BMMain Gary Michael · Haverford, PABuilt 2004 · S/N E-3588 N129CBBurton Aviation LLC · Melbourne, FLBuilt 2026 · S/N 11171 N129CDCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11408 N129CMWoodhaven Air LLC · Blue Springs, MOBuilt 1958 · S/N 35625 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N129DMDon W Richie And Dennis S Gale LLC · Lewes, DEBuilt 2016 · S/N 1325 N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N129GPPafford Holdings LLC · Ruston, LABuilt 2005 · S/N 1366 N129JYelatrek LLC · Tempe, AZBuilt 2023 · S/N 9599 N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812 N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088 N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208 N129PLAbh Aviation LLC · Escondido, CABuilt 2013 · S/N 0651 N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448 N129QFlying J Aviation Pllc · League City, TXS/N TC-847 N129RJKenney Donill · Lake Worth, FLBuilt 1980 · S/N E-1752 N129STAzell LLC · Springfield, MOBuilt 1965 · S/N TC-835 N129TJ3d Construction Properties LLC · Parkersburg, WVBuilt 2014 · S/N 0712 N129TRDawson Aircraft Inc · Clinton, ARBuilt 1994 · S/N E-2888 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444

Back to AD 2000-23-21