OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,135

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.

N10MNAircraft Sales Of America LLC · Fenton, MIFirst renewal noticeBuilt 1970 · S/N TE-831N10NFThompson Benjamin K · Nevada, TXBuilt 1976 · S/N TJ-64N10NNK&L Air LLC · Lakewood Ranch, FLBuilt 1994 · S/N E-2895N10PBNeves Frank Jr · North Miami Beach, FLBuilt 1974 · S/N 34-7570031N10PPWendellco LLC · Harlingen, TXBuilt 1983 · S/N 46-8408011N10PRVillalobos Jesus F · Farmington, NMBuilt 1961 · S/N 310-0032N10PWAircraft Partner Holdings Inc Trustee · BerlinBuilt 1995 · S/N E-2950N10PXHls Equipment LLC · Spokane Valley, WABuilt 2016 · S/N 1453N10RAOne Six Bravo LLC · Kernersville, NCBuilt 2021 · S/N 5069N10RDValiair Lc Trustee · Casper, WYBuilt 2023 · S/N 9300N10RP4f Aviation LLC · Palmer Lake, COBuilt 1972 · S/N 21059779N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418N10SBSackett Michael · Nordman, IDBuilt 1975 · S/N 21060920N10TTHays John J Jr · Denton, TXBuilt 1978 · S/N P21000056N10UALnj LLC · Olympia, WABuilt 2011 · S/N 0188N10UDMacasek John · Caledonia, MSBuilt 1968 · S/N D-8676N10ULSurber Medical Enterprises LLC · Waverly Hall, GABuilt 1964 · S/N D-7430N10URXtiri LLC · St George, UTBuilt 1955 · S/N 32184N10VTDalton Aero LLC · Dalton, GABuilt 2023 · S/N 9482N10WPawsitive Rate LLC · Corpus Christi, TXBuilt 1984 · S/N TJ-448N10WDEgmond Aircraft LLC · Lewes, DEBuilt 1964 · S/N NAV-4-2494N10WQQuirion Paul J · Fairbanks, AKBuilt 1956 · S/N 33310N10XEBlaikie Thomas B · Kenner, LAFirst renewal noticeBuilt 1973 · S/N 340-0221N10YSeitz William D · Gordonville, TXBuilt 1972 · S/N 21059697N10YDDavenport Jimmy J · Hayesville, NCBuilt 1965 · S/N 27-2892N10YTN10yt LLC · Missoula, MTBuilt 1976 · S/N 21061460N10ZN10z LLC · Sandy Springs, GABuilt 2022 · S/N 2491N10ZWBurnett Wade C · Sandpoint, IDBuilt 2001 · S/N 0055N11000Thunder Duck Aviation II LLC · Ashburn, VABuilt 2025 · S/N 11000N1100GKcd Enterprises Inc · Bartlesville, OKBuilt 1996 · S/N E-3049N1100TSale Reported · Olympia, WASale reportedS/N 22020N1102GGlassy Water LLC · Brier, WABuilt 1977 · S/N 18503521N1102WEckberg Stephen A · Merritt Island, FLBuilt 1973 · S/N D-9472N1103QHenderson Phillip Kimon III · Benton Harbor, MIBuilt 1963 · S/N 310H0103N1105QSundale Aviation Inc · Erwinna, PABuilt 1963 · S/N 310H0105N1105ZRsd Aviation LLC · Austin, TXBuilt 2018 · S/N 1684N1106QOrellana Wilson · Hesperia, CAS/N 310H0106N1106XVan Vleet Merlin D · Kingman, AZBuilt 1975 · S/N 34-7570212N1107QValiair Limited Co Trustee · Casper, WYBuilt 1963 · S/N 310H0107N1107UBeech Air LLC · Carolina Beach, NCS/N E-3077N1107XHumphreys Steven Craig · Soldotna, AKBuilt 2019 · S/N 003N1108C1992 Investment Group LLC · Birmingham, ALBuilt 2021 · S/N 2412N1108N08n Inc Trustee · Wilmington, DEBuilt 1997 · S/N E-3078N1108TSale Reported · Crystal, MNSale reportedBuilt 2011 · S/N 2114N1108WEtemadian Ali · Upland, CABuilt 1998 · S/N EA-611N1109MPatrick Chris J · Paris, ILBuilt 1970 · S/N 33701309N110BDArgus Craig J · Atlantic City, NJBuilt 1981 · S/N 21064427N110BWAtwater David C · Pompano Beach, FLS/N 1538N110CAFargo Jet Center LLC · Fargo, NDBuilt 1975 · S/N 34-7570219N110CBBos Bernard D · Astoria, ORBuilt 1974 · S/N 74-30678
Back to AD 2000-23-21