OpenAirDocs.org
AD 2000-23-21

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

N2533KDomicile Capital LLC · Monterey, CABuilt 2005 · S/N 41531N2533QBusse Alana · Thousand Oaks, CABuilt 1966 · S/N 18257733N2533RAdams Michael B · Scottsdale, AZBuilt 1967 · S/N 18258233N2533TMende Jeffrey · Crystal Lake, ILBuilt 1969 · S/N NAV-4-2533N2534RRobuck Dale J · Knoxville, IABuilt 1967 · S/N 18258234N2535PN2535p LLC · Verona, WIBuilt 2006 · S/N 41568N2535QDerodeff Stephan A · Nipomo, CABuilt 1966 · S/N 18257735N2535XAviator Ventures LLC · Valrico, FLBuilt 2006 · S/N 41573N25367Robinson Stephen C · Garrison, NDBuilt 2005 · S/N 41503N2536GDittmer Larry J · Basco, ILBuilt 1959 · S/N 51836N2536QWiebe Tim · Newton, KSBuilt 1966 · S/N 18257736N2536XLouscher Steven Trustee · Paullina, IABuilt 1964 · S/N P206-0036N2537GDirigo Aviation LLC · York, MEBuilt 1959 · S/N 51837N2537KPanuski Christopher Louis · Davidson, NCBuilt 1978 · S/N 18052978N2537TBusiness Air Ventures LLC · Georgetown, DEBuilt 1970 · S/N NAV-4-2537N2538MWarren James Rent · Rapid City, SDBuilt 2005 · S/N 41081N2538R1 Point 21 Gigawatts LLC · Auburn, WABuilt 1967 · S/N 18258238N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322N2538THeeren Craig J · Williston, TNBuilt 1970 · S/N NAV-4-2538N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078N2539RWillard John E Jr · Rockwood, MEBuilt 1967 · S/N 18258239N2539TSouthwest Aircraft LLC · Fairacres, NMBuilt 1970 · S/N NAV-4-2539N2539XWhy Drive LLC · Houston, TXBuilt 2006 · S/N 42505N253AJLeikur Inc · Tulsa, OKBuilt 2024 · S/N 10204N253BCHolliman Enterprises Inc · Edmond, OKBuilt 2023 · S/N 9143N253CDAngell John C · Ann Arbor, MIBuilt 2003 · S/N 0448N253DFFort Greg R · Burien, WABuilt 1976 · S/N 18052686N253DLLa Boots Ventures LLC · Marksville, LABuilt 2010 · S/N 0039N253ESchnack Aviation LLC · Twin Falls, IDBuilt 2008 · S/N 3106N253FDMile High Aviation LLC · Farmingdale, NJBuilt 2024 · S/N 9845N253JC96 Quick LLC · Wilmington, DEBuilt 1963 · S/N CD-673N253JSN253js LLC · Wilmington, DEBuilt 2017 · S/N 4566N253KTInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N E2200N253PZDidiergroup LLC · Orlando, FLBuilt 2018 · S/N 1728N253RLArs Automation Design Inc · Greensboro, NCBuilt 1980 · S/N EA-131N253RRRoland Ronald W Trustee · Mckinney, TXBuilt 1953 · S/N 30253N253SRDara Mortgage Inc · Las Vegas, NVBuilt 2006 · S/N 2034N253WCba Investments LLC · Kalispell, MTBuilt 2004 · S/N 0881N2540MGlobal Emergency Services LLC · Beaumont, TXS/N 41031N2540RFreeman Josh · Turtle Lake, NDBuilt 1967 · S/N 18258240N2540THenningsen Air LLC · Atlantic, IABuilt 1970 · S/N NAV-4-2540N2541AEnergy307 LLC · Casper, WYBuilt 2005 · S/N 41085N2541GDuvall Paul M · Scottsburg, INS/N 51841N2541MWard Gregory D · Philadelphia, MSBuilt 2004 · S/N 41028N2541XEco Flite Service Inc · Lake Elsinore, CABuilt 1964 · S/N P2060041N2542RThordarson Gudsteinn T · La Porte, INBuilt 1967 · S/N 18258242N2542SSierra Systems LLC · Emigrant, MTBuilt 1968 · S/N 337-0842N2542TCavu Aviation LLC · Searcy, ARBuilt 2005 · S/N 41508N2543RSaddlery Air Inc · Des Moines, IABuilt 1967 · S/N 18258243N2544GEnsman Enterprises LLC · Chino Valley, AZBuilt 1959 · S/N 51844
Back to AD 2000-23-21