OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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
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.

N455AKBarr Scott A · Barrow, AKS/N 18260061N455BDArchco II LLC · Bloomfield, NEBuilt 2004 · S/N 1029N455BTMarshall Tristen · Spokane Valley, WABuilt 1964 · S/N TC741N455BZVeetwo Inc · Merritt Island, FLBuilt 1978 · S/N 3433114N455CDSanta Barbara Biplane Tours LLC · Santa Barbara, CABuilt 2004 · S/N 0907N455DSanders Tyler B · Yuma, AZBuilt 1989 · S/N CE-1408N455DCAviation Safety Training International LLC · Butte, MTBuilt 1968 · S/N CJ-13N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118N455FPRobert Corio Inc · Johnston, RIS/N TE-549N455HCBas Part Sales LLC · Greeley, COS/N TC-586N455JRHinaa Hidaa LLC · Chino Valley, AZS/N EA-124N455KBrooks Donald W · Lumberton, NJBuilt 1967 · S/N D-8440N455KGMiguel Paul A · Canyon, TXBuilt 2014 · S/N 0890N455MArnold Curtis L II · Corsicana, TXBuilt 1965 · S/N TC-975N455MCHoffer William M · St Helena Is, SCBuilt 2009 · S/N 411148N455MVGrand Sierra Investments LLC · Kingfisher, OKBuilt 2016 · S/N 4307N455PN455p LLC · Fulshear, TXBuilt 1999 · S/N E3276N455PCPch Inc · Roseville, CABuilt 2006 · S/N 1961N455PGParker Gordon A · Afton, WYBuilt 2006 · S/N 1615N455QSouthern Utah University · Cedar City, UTBuilt 1972 · S/N TC-1441N455RBGh Enterprises Inc · Baton Rouge, LABuilt 1977 · S/N TE-1099N455RMRomeoav8 LLC · Houston, TXBuilt 2021 · S/N 2243N455SDJ&L Aviation LLC · Malta, NYS/N TJ-405N455SPSrb Aviation LLC · Pewaukee, WIBuilt 2007 · S/N 2406N455SRScottie Dog Air LLC · Wilmington, DEBuilt 2006 · S/N 2229N455TBSmith Loren D · Great Falls, MTS/N 310R1860N455TCTompkins Landing Lc · Wayne, NEBuilt 2007 · S/N 2491N455WCHayes William F · Perrysburg, OHBuilt 1969 · S/N 337-1191N4560KRegistered aircraftBuilt 1948 · S/N NAV-4-1560N4560MPhillips William S · Normandy Park, WAFirst renewal noticeBuilt 1978 · S/N CE-770N4561VOrca Wealth Management LLC · New Port Richey, FLBuilt 1976 · S/N U20603052N4562FMcdaniel Dean K · Queen Creek, AZS/N 185-1069N4562MBbt Aviation LLC · Rapid City, SDBuilt 1978 · S/N E-1237N4563BLarose Gary R · Anchorage, AKS/N 31462N4563SMeyerhoff Scott G Trustee · Reno, NVBuilt 1975 · S/N CE-604N4563WE&V Air LLC · Chatsworth, GABuilt 1973 · S/N 18262363N4564XMulti-Time LLC · Jacksonville, FLS/N 34-7670073N4565SGl Aviation LLC · Mcmurray, PABuilt 1975 · S/N E-736N4566BWagnon Bertram L · Anchorage, AKS/N 31465N4566MPalacios Luis A · El Paso, TXBuilt 1978 · S/N TJ-182N4566SWalters G David · Sarasota, FLBuilt 1975 · S/N D-9804N4567BCavu LLC · Boise, IDBuilt 1955 · S/N 31466N4567FPatterson Roland O · Semmes, ALBuilt 1960 · S/N 57314N4567GKris Noone Air LLC · Wilmington, DEBuilt 1965 · S/N 337-0110N4567ZMae Enterprises LLC · La Porte, INBuilt 2025 · S/N 10467N4568CYorde Roger C · North Fort Myers, FLBuilt 1963 · S/N 21058142N4568NBergren Scott W Trustee · Walnut Creek, CABuilt 1978 · S/N 340A0549N4568SYuma Desert Fliers LLC · Yuma, AZFirst renewal noticeBuilt 1975 · S/N CE-605N4569SMiles Lawrence W Jr · Sacramento, CABuilt 1975 · S/N E-745N456ACHotel Quebec I LLC · Mount Pleasant, SCBuilt 2015 · S/N 4249
Back to AD 2000-23-21