Registered aircraft · 47,138

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.

N288WTBas Part Sales LLC · Greeley, COS/N 1594 N2890FAeolus Aviation LLC · Franklin, TNBuilt 1966 · S/N 18256990 N2890WAlbatross Aviation LLC · Lakeville, OHBuilt 1973 · S/N D-9510 N2890YWomble Warren G · Chapel Hill, NCBuilt 1962 · S/N 18253890 N28913Bellas Business LLC · Kalispell, MTBuilt 1973 · S/N 340-0153 N2891ARegistered aircraftBuilt 1953 · S/N 30091 N2891FBayshore Properties LLC · Hagerstown, MDBuilt 1966 · S/N 18256991 N2892FSpeedtape Airways LLC · Williamson, GABuilt 1966 · S/N 18256992 N2892RBuenafe Constance Ann · Santa Fe, NMBuilt 1967 · S/N 18258492 N2893DAshurst Brent H · Westmorland, CABuilt 1951 · S/N 2242B N2894WDavenport Skyler R · Granbury, TXBuilt 1973 · S/N D-9514 N2895AAirspace Aerial Media LLC · Saint Louis, MOBuilt 1953 · S/N 30095 N2895FWilson Paul D · Peachtree Corners, GABuilt 1966 · S/N 18256995 N2895WN2895w LLC · Mount Airy, MDBuilt 1973 · S/N E-457 N28966Life Aviation LLC · Winston Salem, NCBuilt 1979 · S/N 28-7921026 N28967Flying Farmers LLC · Ogden, IABuilt 1979 · S/N 28-7921027 N2896FEvans Gene · Center, MOBuilt 1966 · S/N 18256996 N28971Cullman Daniel H · Kent, WABuilt 1979 · S/N 1041 N2897FDeeck Mechanical Inc · Albemarle, NCBuilt 1966 · S/N 18256997 N2897RGervase Russell G · Farmington, NMBuilt 1967 · S/N 18258497 N2897TAnderson Eric · Pembroke, MAS/N 28-7921028 N2897YRegistered aircraftBuilt 1962 · S/N 18253897 N28988Wittbrich LLC · Union Grove, WIBuilt 1979 · S/N 28-7921029 N28989Buckin 307 Taildraggers LLC · Casper, WYBuilt 1979 · S/N 28-7921030 N2898YKolling Aviation LLC · Spring Valley, MNS/N 18253898 N2899FWashburn Michael D · Farmington, UTBuilt 1966 · S/N 18256999 N289AA289 Aero Holdings LLC · Renton, WABuilt 2026 · S/N 11651 N289AMBoston Family Holdings LLC · Miramar Beach, FLBuilt 2023 · S/N 9066 N289CRNiner Charlie Romeo LLC · Simpson, LABuilt 1974 · S/N 18263496 N289DAHarden Aviation LLC · Washington, PABuilt 2011 · S/N 2082 N289EMorrison Matthew J · Waco, TXBuilt 2022 · S/N 9035 N289KCBonner Aviation LLC · Billings, MTBuilt 2015 · S/N 1223 N289SBHemcka Aviation LLC · Bradenton, FLBuilt 2004 · S/N 1102 N289WRBradbury Douglas W · Pedro Bay, AKFirst renewal noticeBuilt 1957 · S/N 32864 N28ACZiegler Bruce A · Findlay, OHBuilt 1974 · S/N 18263265 N28APAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1978 · S/N 414A0204 N28AXMotion Works LLC · Green Cove Springs, FLBuilt 1982 · S/N TC-2443 N28BSamsen Andrew · Danville, INBuilt 2023 · S/N 9165 N28BJBj Aviation Inc · Littleton, COBuilt 1996 · S/N 34-47017 N28BKMooster Aviation LLC · Niceville, FLBuilt 2023 · S/N 9199 N28BRFlying Rock Aero LLC · Sunnyvale, CABuilt 1986 · S/N 468608045 N28BWJv Aviation Group Inc · La Puente, CABuilt 1965 · S/N TC-957 N28BXBoyle Brendan C · Apex, NCBuilt 2025 · S/N 10904 N28CCGulf Airbatics Ltd · Jennings, LABuilt 1979 · S/N 414A0226 N28CNRoman Stephen B · Minnetrista, MNBuilt 1976 · S/N CN-1 N28CPArk Investments Inc · Ridgeland, MSBuilt 1971 · S/N D-9213 N28DBEdson Franz R · Waterford, CTBuilt 1970 · S/N D-9139 N28DJMccrorie David M · Port Angeles, WABuilt 1964 · S/N D-7320 N28ERSmith John C · Germantown, TNBuilt 1966 · S/N 18257645 N28FNValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10834

Back to AD 2000-23-21