OpenAirDocs.org
AD 2000-23-21

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

N141DPHbdb Aviation LLC · Los Angeles, CABuilt 2011 · S/N LIV-471N141ECDcomm Inc · Austin, TXBuilt 2007 · S/N 2556N141HCKom Terry M · Brandon, MSBuilt 1963 · S/N CD-604N141HPBrankin Enterprises Inc · Dover, DES/N E-1815N141HTBazman Aviation LLC · Harbor Springs, MIBuilt 2006 · S/N 2219N141JWGray William C · Starkville, MSBuilt 2010 · S/N 0058N141KJVelox Aegis Inc Trustee · Wilmington, DEBuilt 2014 · S/N 0832N141KTAscensis LLC · Wilmington, DEBuilt 2022 · S/N 8537N141PGIshikawa Brendon · Davis, CABuilt 2008 · S/N 1921N141TWHunt Bradley · Wichita Falls, TXBuilt 1974 · S/N D-9634N141WBElevated Dreams Aviation LLC · Huntington, NYBuilt 1976 · S/N 18265249N141WSCopper Spike Aero LLC · Douglas, WYBuilt 1965 · S/N D-7995N141XLHigh Velocity Flying LLC · Centennial, COBuilt 2024 · S/N 3RX084N1420EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268177N1420GRamsey April Dawn · Saraland, ALBuilt 1962 · S/N TC-238N1420NKlomhaus Paul · Poplar, WIBuilt 1978 · S/N 310R1398N1421SHoversland Leroy Dvm · Ronan, MTBuilt 1976 · S/N 18264977N1422MSmith Christopher J · Saint Augustine, FLBuilt 2006 · S/N ES-155N1422TRead Travis · Lumberton, TXBuilt 1982 · S/N 34-8133277N1423ABijur David · Truckee, CAFirst renewal noticeBuilt 2007 · S/N 41719N1423CGlovis Mark S · Wyandotte, MIBuilt 2003 · S/N 1318N1423GHolscher Barclay M · Amery, WIBuilt 1962 · S/N CD-447N1424GLothlorien LLC · Two Harbors, MNBuilt 1961 · S/N CD-445N1425MRhino Capital Holdings LLC · Bonaire, GABuilt 1974 · S/N P3370162N1426MKing Corbin B · Lubbock, TXS/N 18264324N1427GCarter Geoffrey R · Ormond Beach, FLBuilt 1962 · S/N D-6903N1428MBaja Air LLC · Wilmington, DEBuilt 1975 · S/N 18264326N142AZLorenz Reiff A · Kettering, OHBuilt 2022 · S/N 3RX068N142BKCirrus Sr22 11508 Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11508N142CGlc Equipment Leasing LLC · Paragould, ARBuilt 2018 · S/N 4714N142CTMiddleton Charles H · Hamilton, INFirst renewal noticeBuilt 1976 · S/N 310R0629N142CWTable Rock Aviation Inc · Galena, MOBuilt 2006 · S/N 1911N142DCirrus Design Corp · Knoxville, TNBuilt 2017 · S/N 4587N142DBN 10 Aviation LLC · Gallatin, TNBuilt 2019 · S/N 1894N142FGall Peter · Morgantown, WVBuilt 1966 · S/N TE-221N142GDDeaero LLC · Darwin, MNBuilt 1980 · S/N 34-8070314N142GXDicey Emery B · Port Orange, FLBuilt 2004 · S/N 29-0342N142HGN142hg LLC · Manhasset, NYBuilt 1969 · S/N D-9020N142KMDearing Michael P · Anderson, TXBuilt 2008 · S/N 411082N142KREal Properties · Vail, COS/N 31-0122N142LCAerocareers Nfp · Columbia, ILBuilt 1998 · S/N 40003N142MPeterson Dana Timothy · Eldersburg, MDBuilt 1960 · S/N D-6585N142MCCassen Mark E · Wilson, WYBuilt 1973 · S/N TC-1579N142MSPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-8331017N142PFirelands Management LLC · Sandusky, OHBuilt 2024 · S/N 10220N142RDS-Turns LLC · Indn Hbr Bch, FLBuilt 2024 · S/N 10361N142RSReinmuth Michael W · Lopez Island, WAS/N 18253832N142SMed Care Inc · Grand Island, NEBuilt 1975 · S/N TH-693N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635N142SFN142sf LLC · Scottsdale, AZS/N 1527
Back to AD 2000-23-21