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.

N1836XRodney William Debaun Family Lp · Midlothian, TXBuilt 1964 · S/N 18255936N1836ZBrown Farms Inc · Central City, NEBuilt 1981 · S/N CE-970N1837Nfm Enterprises LLC · Wurtsboro, NYBuilt 1965 · S/N 2009N18378Lodi Airport Maintenance Corp · Las Vegas, NVS/N E-1106N1837HYeagley Daun III · Moraine, OHBuilt 1959 · S/N 35937N1837LHornby Mark H · New Bern, NCBuilt 1976 · S/N D-9881N1837ZBert Aviation LLC · Clemmons, NCBuilt 1981 · S/N D-10317N18381Texas Aero Services 1 LLC · Frisco, TXBuilt 1977 · S/N CE-732N1838LGordon Martin A · South Amboy, NJS/N TC-2008N1838MGenesis Aircraft Services Of Martin County LLC · Stuart, FLBuilt 1975 · S/N 18264461N1838RSix Zero Zulu LLC · Kalispell, MTBuilt 1981 · S/N E-1916N1838XSkinner Norman D · Osceola, IABuilt 1964 · S/N 18255938N1838ZAgee Mark L · Greenacres, WABuilt 1962 · S/N 205-0038N18394Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1121N18396Drec 0419 LLC · Carson, CAS/N TE-1109N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739N1839HFly 172n LLC · Peoria, AZBuilt 1977 · S/N 34-7770152N1839RBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 18502554N1839WTown & Country Auto Sales LLC · Winchester, KYBuilt 1973 · S/N TC-1514N183BWilliams John · Omaha, NES/N BG-414N183BMAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 2014 · S/N 4080N183CACloud Asset LLC · Thomasville, GABuilt 2026 · S/N 11195N183CDRegistered aircraftBuilt 2004 · S/N 0921N183CRBekway Builders LLC · Charleston, SCBuilt 1976 · S/N 18264029N183CSN183cs LLC · Canaan, NYBuilt 2009 · S/N 2031N183EHarkins Harrison J Trustee · Hayden, IDBuilt 1982 · S/N E-2034N183KSN183ks LLC · Houston, TXBuilt 2019 · S/N 1891N183PHVestal Aviation LLC · Thomasville, NCBuilt 2010 · S/N 0062N183QDrajesk Jeffrey F · Fish Creek, WIBuilt 1965 · S/N D-7883N183RLea Brandon Wayne Sr · Bartlett, TNBuilt 1957 · S/N D-5155N183SFGrand Cove Support Services LLC · Denver, COBuilt 2018 · S/N 1737N183SKHill Vicki · Saint Joseph, LABuilt 1977 · S/N 18052824N183SRRyder Aviation LLC · Tucson, AZBuilt 2025 · S/N 10401N183SVQuality Feed Grains Inc · Harrison, ARS/N 05-301031N183VGriffiths Aero LLC · Centerville, OHBuilt 2008 · S/N 3125N183VBRegistration Pending · Palm City, FLRegistration pendingBuilt 1977 · S/N E-1097N183XIcg Aviation LLC · Ankeny, IABuilt 2017 · S/N 1479N184Rocky Mountain Hangars LLC · Longmont, COBuilt 1974 · S/N P3370206N18402Ohlhauser Devin · Bismarck, NDBuilt 1977 · S/N E-1117N18403Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1120N1840WPutz Aeroplanes LLC · Bryan, TXBuilt 1973 · S/N D-9431N18413Cook Brian D · La Vernia, TXBuilt 1977 · S/N CE-736N1841RPatton Ronald V II · Keizer, ORBuilt 1974 · S/N 18502556N1841WN1841w LLC · Plant City, FLBuilt 1973 · S/N CE-437N1841XBoland Thomas · Pewaukee, WIBuilt 1964 · S/N 18255941N18429Withers John Justin · Paris, TXS/N CE-937N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433N1842WNorthwoods Aviation · Marion, IAS/N CE-438N1842XRichey Perry A · Willow, AKBuilt 1964 · S/N 18255942N1842ZVermont Skydiving Adventures Inc · Bristol, VTBuilt 1962 · S/N 205-0042
Back to AD 2000-23-21