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.

N184PSStrama Aviation LLC · Ocala, FLBuilt 1965 · S/N 310J0111N184PWCardwell Aubrey Lynn · Spring Branch, TXBuilt 1979 · S/N 18266871N184QSchmuker David Joseph · Grand Rapids, MIBuilt 1959 · S/N D-5954N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302N185Ellison Jeremy Trustee · Dayton, NVBuilt 1974 · S/N 18502582N18500Thompson Dennis E · Anchorage, AKBuilt 1977 · S/N 18503305N1850FMarcus Air LLC · Plano, TXBuilt 1981 · S/N TE-1195N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268N18521Island Air LLC · Eagan, MNBuilt 1979 · S/N 185-03812N1852EMarshall Dennis Ray Jr · Pottsboro, TXS/N 310R1587N1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 21058752N1852HI Fly Stl LLC · Saint Louis, MOBuilt 1959 · S/N 35952N1852RHartman Craig T Trustee · Chugiak, AKBuilt 1975 · S/N 18502567N1852SReg Aeronatics LLC · Bradenton, FLBuilt 1981 · S/N E-1923N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1852XPhillips Lane · Dawson, TXBuilt 1965 · S/N 18255952N1853BAltius Aviation LLC · Syracuse, NYBuilt 1981 · S/N TC-2420N1853QSend North · Anchorage, AKBuilt 1975 · S/N U20602943N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477N1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754N1854KNelson Law Firm Pc · Billings, MTBuilt 1981 · S/N E-1927N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N1854ZBargabos William M · Wasilla, AKS/N 2050054N1855S1855 Sierra LLC · Brighton, MIBuilt 1981 · S/N CE-980N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591N1856FCraig Marc · Mountain City, TXBuilt 1981 · S/N E-1931N1856HVieman John D · Owensville, MOBuilt 1959 · S/N 35956N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889N1856RRich Gary L · Anchorage, AKBuilt 1974 · S/N 18502571N1856TCohan Peter E · Trinidad, CABuilt 2015 · S/N 4279N1856XRobert Yost Enterprises · Saint Francis, KSBuilt 1964 · S/N 18255956N1856ZBromley Wayne B · Colwich, KSBuilt 1981 · S/N CE-977N1857Saigal Sanjay · Menlo Park, CABuilt 2003 · S/N 1298N1858LAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N CE-646N1858MCrowley Michael A · Wake Forest, NCBuilt 1972 · S/N 33701458N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N1858XSalem Aero Club Inc · Bridgeton, NJBuilt 1964 · S/N 18255958N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058N1859CHadley Aviation LLC · Kent, CTBuilt 1981 · S/N CE-986N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759N1859P1859p LLC · Fulton, MOBuilt 1982 · S/N E-1995N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503N185ARortvedt Robert S · Mukwonago, WIBuilt 1973 · S/N TH-332N185AAEoff Joe · Salem, ORS/N 185-0881N185ABKinneen Simon N · Nome, AKBuilt 1981 · S/N 18504348N185ADDurrett Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18503576N185AEDbl LLC · Hays, KSBuilt 1973 · S/N 18502125N185AFTanada Lake Lodge LLC · Grand Junction, COBuilt 1973 · S/N 18502236N185AHHattenburg Scott L · Chugiak, AKBuilt 1981 · S/N 18504263
Back to AD 2000-23-21