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.

N158DGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2016 · S/N TH-2460N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178N158KSBowerman Marvin · Montgomery, TXBuilt 1982 · S/N TJ-419N158LFPro Tech Track & Tennis Management Lp · Bullard, TXBuilt 2014 · S/N TH-2425N158MRT-Bird LLC · Byron Center, MIBuilt 2011 · S/N TH-2312N158MST Hiers LLC · Barney, GABuilt 2017 · S/N TH-2492N158NRoss Adam · Texarkana, TXBuilt 1981 · S/N EA-197N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444N158PCSewalt Steve · Victoria, TXBuilt 2018 · S/N TH-2500N158RFBeech Bound LLC · Morgantown, WVBuilt 1978 · S/N TH-941N158RMWings Lc · Baltimore, MDBuilt 1988 · S/N TH-1543N158RSRegistration Pending · Wallace, CARegistration pendingBuilt 1981 · S/N TJ-359N158RWHeartfield J Thad · Beaumont, TXBuilt 2008 · S/N TH-2221N158RXMurkowski Francis M · Anchorage, AKBuilt 1979 · S/N 18503784N158SWFern Leasing Corp · Larkspur, CABuilt 1999 · S/N TH-1921N158TAFerndock LLC · Monroe, LABuilt 2008 · S/N 411005N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008N158YBCommercial Bank Aviation LLC · Harrogate, TNBuilt 2014 · S/N TH-2410N158ZLOlds Curtis J Jr · Elizabeth City, NCBuilt 1957 · S/N BG-344N1591FBaer Monte Wayne · Ronan, MTBuilt 1966 · S/N 185-0973N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381N1592CPulver Douglas A · Kenockee, MIBuilt 1953 · S/N 30292N1592FReynolds Frederick A · Pilot Point, AKBuilt 1966 · S/N 185-0974N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832N1592MDumais Robert J · Tilton, NHBuilt 1975 · S/N 18264382N1592SRoach Christopher A · Mustang, OKBuilt 1962 · S/N CD-471N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383N1593CPeacock Richard M · Swansboro, NCS/N 30293N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637N1593SHoward Paul D Jr · Williamson, WVS/N D-7013N1593ZButler Richard Austin · Gatesville, TXBuilt 1961 · S/N D-6885N1594CFlyrs Field · Anchorage, AKBuilt 1953 · S/N 30294N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833N1594WFinnigan Jeffry A · Hoodsport, WABuilt 1972 · S/N CD-1290N1594ZWondra Wayne L · Friendswood, TXBuilt 1961 · S/N D-6886N1595FVertical Horizon Aviation LLC · Sandown, NHBuilt 1966 · S/N 185-0977N1595LClemens Jerry W · Parsons, KSBuilt 1976 · S/N D-9869N1595UJoiner Aviation LLC · Vinemont, ALBuilt 1973 · S/N U20602269N1595WHope John W · Greeneville, TNFirst renewal noticeS/N TC-1448N1596CFennell Kenneth J · Palmer, AKBuilt 1953 · S/N 30296N1596DSchneider Carl S · Tulsa, OKBuilt 1972 · S/N CD-1297N1596GN1596g Inc · Peachtree City, GABuilt 1974 · S/N 340-0507N1596MKret Geoffrey W · Godley, TXBuilt 1975 · S/N 18264386N1596TPlane Crazy Inc · Page, NDBuilt 1973 · S/N 4140376N1596ZBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N D-6887N1597LTougas John D · Huntingtown, MDS/N CE-638N1597MDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 18264387N1597SJones William F · Seneca, SCBuilt 1962 · S/N CD-540
Back to AD 2000-23-21