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.

N120HAAstley Mark C · Wayne, NJBuilt 1977 · S/N 340A0295 N120JFElad LLC · Bend, ORFirst renewal noticeBuilt 2019 · S/N 1981 N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636 N120LDJ & G Aircraft LLC · Chandler, AZBuilt 1961 · S/N NAV-4-2355 N120MCigarroa Jorge J · Laredo, TXBuilt 2008 · S/N LS-208 N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248 N120MXSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2015 · S/N 2281 N120PCHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0079 N120TKNew Leaf Consulting Inc · Raleigh, NCBuilt 2012 · S/N 2156 N120TNLf Cirrus LLC · Sarasota, FLBuilt 2024 · S/N 10067 N120TWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 31-0057 N120WPHentschel Ernest · Galloway, NJBuilt 2005 · S/N 1630 N1211DWest Ridge Ttx LLC · Parker, TXBuilt 2008 · S/N 411104 N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774 N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418 N1213LBlack Jesse M Jr · Gainesville, GABuilt 1969 · S/N 18259551 N1213MOlson Sandra K · Edmonds, WABuilt 2006 · S/N 42543 N1213VKarma Aviation LLC · Little Rock, ARBuilt 2022 · S/N 8981 N12144Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1958 · S/N 31038118 N1214G9791m LLC · Tacoma, WABuilt 1975 · S/N 414-0652 N12158Caccavale John J · Oakdale, NYBuilt 1978 · S/N JC1 N1215CColer Aviation Ltd · Zanesville, OHBuilt 2024 · S/N 9776 N1215MBieber Dale E · Coralville, IABuilt 1977 · S/N 21061924 N1215TShepphird John C · Reno, NVBuilt 1966 · S/N TE-102 N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653 N1216MHayward Flying Club · Hayward, CABuilt 1975 · S/N 18264245 N1216NDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2003 · S/N 0549 N1216VKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N R1722143 N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779 N1217ZZillmer Kenneth E · Ocklawaha, FLS/N CD-304 N1218Nogle Charles H · Champaign, ILFirst renewal noticeBuilt 1956 · S/N BG-163 N1218MGmm Aviation LLC · Los Altos, CABuilt 2025 · S/N 10774 N1218PMcc Aero LLC · Douglas, NDBuilt 2006 · S/N 1677 N1218ZHutsell James M · Miamisburg, OHBuilt 1961 · S/N D-6682 N1219PJersey Christopher M · Willis, TXBuilt 1977 · S/N 18265701 N1219SAviodeck Inc Trustee · Wilmington, DEBuilt 2015 · S/N 1219 N121ABAbl Jets LLC · New York, NYBuilt 2024 · S/N 10279 N121ACBrooks Jimmie Patrick · New Braunfels, TXBuilt 2018 · S/N 1812 N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254 N121AGCedar Wings Holdings Inc Trustee · Wilmington, DEBuilt 2001 · S/N 03 N121AMEastern Stearman Inc Trustee · Leesburg, VAS/N CE-1126 N121BCCavanaugh Collections Inc · Addison, TXS/N G-123 N121BDKorn Air LLC · Fort Lauderdale, FLS/N 414A0297 N121BEKrdm LLC · Fallon, NVS/N D-7920 N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893 N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413 N121BRSmith Tad E · Colorado Springs, COS/N 1697 N121BWLester Jon M · Lancaster, OHBuilt 1979 · S/N TC-2256 N121CBClark Andrew R · Woodside, CABuilt 1976 · S/N 340A0087 N121CDChampion Aviation Enterprises LLC · Acworth, GABuilt 2024 · S/N 9888

Back to AD 2000-23-21