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.

N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N123MNFoster Aviation And Mobile Maintenance LLC · Dublin, VABuilt 1972 · S/N 310Q0602 N123PCRegistered aircraftBuilt 2020 · S/N 2110 N123PKNunley Lonnie · Show Low, AZBuilt 1998 · S/N LRK-017 N123PRAerotransporters Inc · San Juan, PRBuilt 2006 · S/N ES-019 N123RGChurch Brett L · Whitefish, MTBuilt 1968 · S/N D-8816 N123RKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1980 · S/N CE909 N123RLBastiano Richard A · Elba, NYBuilt 1966 · S/N 321 N123TBTango Bravo LLC · Wilmington, DEBuilt 1979 · S/N 340A0795 N123TDVinanam Aviation LLC · Cupertino, CABuilt 1977 · S/N 340A0307 N123TMJaars Inc · Waxhaw, NCS/N U20601768 N123TWGrandy Boyd · Smoot, WYBuilt 1974 · S/N E-518 N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004 N123UPApache Underground And Excavating LLC · Lakeside, AZBuilt 1969 · S/N 18259985 N123USLow Gary Mike · Southside, ARBuilt 1982 · S/N TH-1335 N123VGCrepco LLC · Benton, ARBuilt 2002 · S/N 0383 N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102 N123VPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2019 · S/N 1914 N123VRLewis Edward M · Mesquite, NVS/N 210-59891 N123WBHighview LLC · Brentwood, TNBuilt 1978 · S/N TH-937 N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997 N123X123x LLC · Seattle, WABuilt 2024 · S/N 10327 N123XAOkruch Aviation LLC · Tempe, AZBuilt 2025 · S/N 10787 N123XCEiger Aviation LLC · Woodstock, ILBuilt 2002 · S/N 0345 N1240AAlfa Monkey LLC · Wolfforth, TXBuilt 1969 · S/N D-9028 N1240GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 310Q1091 N1240MElk Creek Investments LLC · Helena, MTBuilt 1975 · S/N 18264255 N1240VHeink Philip · Lexington, KYBuilt 1976 · S/N R1722150 N1241GCastanon Mike · Perryton, TXBuilt 2007 · S/N 41777 N1241ZFeatherston Jacob Eric · Ferris, TXBuilt 1961 · S/N D-6701 N1242GHeathington A H · Georgetown, TXBuilt 1974 · S/N 310Q1093 N1242MHenninger Bradley J · Green Cove Springs, FLS/N 18264256 N12434Aviation S And S LLC · Miami, FLBuilt 1983 · S/N 414A1002 N1243MRegistered aircraftBuilt 1975 · S/N 18264257 N1243VAlexander Arlene Myers · Sandwich, MABuilt 1976 · S/N R1722151 N1243XAircraft Partner Holdings Inc Trustee · BerlinBuilt 2007 · S/N 41755 N12445Old Style Aircraft LLC · Ellsinore, MOBuilt 1932 · S/N 3598 N1244CCoulter Michael Ryan · Rehoboth Beach, DEBuilt 2019 · S/N 1953 N1244YBurbank Dennis · Arcadia, OKBuilt 1966 · S/N TE-253 N1245AAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 414A1201 N1245BPositive Flight LLC · San Ramon, CABuilt 1975 · S/N 18264060 N1245SMccain Michael E · Sun Valley, NVBuilt 1976 · S/N 18264814 N1246VGifford Jeremy C · Stephenville, TXFirst renewal noticeBuilt 1976 · S/N R1722152 N1247GNafziger Aviation Leasing LLC · Wittman, MDBuilt 1974 · S/N 310Q1098 N1247SShurma Ramesh · Hayward, CABuilt 1976 · S/N 18264816 N1248DHamilton Dwight A · Umatilla, FLBuilt 1966 · S/N CE18 N1248SBodolay John M · Fredericksburg, VABuilt 1976 · S/N 18264817 N1249CDane Aviators LLC · Waunakee, WIBuilt 2003 · S/N 1268 N1249SClemans Alan J · Guymon, OKBuilt 1976 · S/N 18264818 N124AWCyalco Aviation LLC · Spencer, IABuilt 1965 · S/N TC-942

Back to AD 2000-23-21