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.

N39JApex 1996 LLC · Kilgore, TXS/N 18052274N39JBHarvey Hath R · Lubbock, TXBuilt 1988 · S/N CE-1233N39JSWestland Business Services Inc · Gallatin Gateway, MTBuilt 2023 · S/N 9163N39KCCapital Holdings 245 LLC · Newark, DEBuilt 2024 · S/N 10373N39KDUfnn Aviation LLC · Lake Charles, LABuilt 2006 · S/N 1659N39LFFeingersh Larry · Houston, TXBuilt 2023 · S/N 9531N39MBN39mb LLC · Wilmington, DEBuilt 2002 · S/N 1199N39MPMission Aviation Training Academy · Arlington, WABuilt 1965 · S/N U206-0288N39PMBank Of Utah Trustee · Salt Lake City, UTS/N 34-8233049N39PRAeroplanes LLC · Cary, NCBuilt 1965 · S/N TE-23N39PSSmith Justin Dean · Dayton, TNS/N 18258921N39PVLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2012 · S/N E-3985N39RHOlympic View Aircraft LLC · University Place, WABuilt 1977 · S/N TE-1113N39TCPutnam Larry Paul · Tucson, AZBuilt 1979 · S/N E-1486N39TFFountain Timothy E · Miami Beach, FLBuilt 1976 · S/N CE-636N39TKCold Water Aviation LLC · Wabasso, MNBuilt 1983 · S/N EA-394N39TPAnderson Robert K · Cleveland, TNBuilt 1969 · S/N TE-780N39VFLight Source Inc · Charlotte, NCBuilt 2020 · S/N 2231N39VKRegistered aircraftS/N VAC-68-77N39VPCare Flight LLC · Camden, DEBuilt 2014 · S/N 0848N39WGAerojet Solutions LLC · Sarasota, FLBuilt 2009 · S/N ES-39-AN39WVLojac Air LLC · Yukon, OKBuilt 2008 · S/N 3196N3AFAf Air LLC · Tulsa, OKBuilt 2025 · S/N 10568N3AQSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 31744N3BCBenedict Larry · Dexter, NMBuilt 1956 · S/N 33947N3BDCopley Johnnie H · Minooka, ILBuilt 1979 · S/N 18267206N3BGHildreth James D · Kennedy, ALBuilt 1967 · S/N D-8612N3BRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N D-9447N3BW4rc LLC · Kenedy, TXBuilt 1976 · S/N D-9870N3CBAk Aviation LLC · Melbourne, FLBuilt 2025 · S/N 11083N3CCN3cc LLC · Auburn, ALBuilt 2018 · S/N 1807N3CFFlying Success LLC · Apex, NCBuilt 2025 · S/N 10580N3CHElliott Frank F · Mojave, CABuilt 1970 · S/N 33701282N3CK3ck LLC · Bellevue, WABuilt 2018 · S/N 1805N3CMOxbow Investments LLC · Sonora, CABuilt 1972 · S/N P337-0025N3CNCheck Six LLC · Champaign, ILBuilt 1981 · S/N BG-198N3CSStone Clifford F Jr · Corning, CABuilt 1972 · S/N CFS711N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeBuilt 1970 · S/N 414-0056N3DRStenger Max H · Bartow, FLBuilt 1993 · S/N 763HN3DWWhite Robert D Trustee · Colorado Springs, COBuilt 1973 · S/N 18262003N3DXMchugh Michael J Trustee · Hailey, IDBuilt 1973 · S/N D-9531N3DZXtreme Flying Club LLC · Gansevoort, NYS/N 33534N3EAEarle Aircraft Inc · Hastings, FLS/N CD-1193N3EHHoppe Nicholas J · Big Lake, AKBuilt 1961 · S/N 18051020N3ELTwo If Buy LLC · Nashua, NHBuilt 1978 · S/N 340A0525N3EM3em LLC · Karnack, TXBuilt 1981 · S/N P21000722N3FRValiair Limited Company Trustee · Casper, WYS/N R172-0237N3GWN3gw LLC · Champaign, ILBuilt 2024 · S/N 10381N3HERidgemont Real Estate Inc · Huntington Woods, MIBuilt 1974 · S/N TC-1710
Back to AD 2000-23-21