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.

N282DMSkyshoe II LLC · Beverly, MABuilt 2021 · S/N 5035N282EEFogprop N282ee LLC · Bolinas, CABuilt 2005 · S/N 1619N282EL282el LLC · Pendleton, ORS/N 182-67682N282JLSieck Joshua · Edmond, OKBuilt 1967 · S/N TE-355N282JPMarshalls Sanitation Services LLC DBA · Fallon, NVBuilt 1977 · S/N 18265923N282PHMission Padamo Aviation And Support Inc · Luray, VABuilt 1980 · S/N U20606068N282RTenere Ventures LLC · Wilmington, DEBuilt 1981 · S/N CE-951N282RFDevault Michael E · Fairmont, WVBuilt 1968 · S/N 18259466N282THAero Sky Inc · Terrace Park, OHBuilt 2019 · S/N 4748N282TMWhite C Derrick · Southlake, TXS/N 1468N282TWLake Of The Woods Aviation LLC · Baudette, MNBuilt 1977 · S/N 18265943N282XBrekken Chris · Prescott, WIBuilt 1975 · S/N 6112CN2830AMarathon Heater Inc · Del Rio, TXBuilt 1970 · S/N E-201N2830RCae Flying Club Of Ohio · Toledo, OHBuilt 1967 · S/N 18258430N2831KBjorkman Glenn A · Goleta, CABuilt 1979 · S/N 18053092N2832RMabe Bradley L · Cascade, IDBuilt 1967 · S/N 18258432N2833AMamuzich Robert J DBA · Deming, NMS/N 30033N2833RRegistered aircraftS/N 18258433N2833YLancaster Mark E · Buffalo, SCBuilt 1962 · S/N 18253833N2834ADalton John B · Dallas, ORBuilt 1953 · S/N 30034N2834RPence Levi B · Quincy, CABuilt 1967 · S/N 18258434N2834YAvance Aircraft LLC · Wilmington, DEBuilt 2015 · S/N 4254N2835AAllen Airplane LLC · Durango, COBuilt 1953 · S/N 30035N2835EGonzalez Roberto Jr · Madera, CAS/N 18268213N2835FAdams Stephen L A · Fortuna, CAS/N 18256935N2835KGardner Thomas W · Lincoln, MEBuilt 1979 · S/N 18053093N2835NDelsair Inc · Maitland, FLBuilt 1979 · S/N 28R-7931216N2835RLander Kirt E · Kingman, AZBuilt 1967 · S/N 18258435N2835YRafter S Contractor Services LLC · Cuero, TXBuilt 1962 · S/N 18253835N2836ABond Darren R · San Antonio, TXBuilt 1953 · S/N 30036N2836DSale Reported · Yucaipa, CASale reportedBuilt 1966 · S/N 411-0190N2836FPaul Jr Johnny D · Camden, SCBuilt 1966 · S/N 18256936N2836RWorthington David C Trustee · Saratoga, WYBuilt 1967 · S/N 18258436N2836YAyers Janet S · London, KYBuilt 1962 · S/N 18253836N2837AGreen Tree Aviation LLC · Provo, UTBuilt 1979 · S/N 28-7921050N2837ELincoln Bruce · Lake Odessa, MIBuilt 1979 · S/N 28-7921052N2838KOrtman James W · Bozeman, MTBuilt 1979 · S/N 18053088N2838RFairbanks Mark J · Kotzebue, AKS/N 18258438N2838WFreebird LLC · Leawood, KSBuilt 1973 · S/N CE-446N2839AAldrich David S · Unity, MEBuilt 1953 · S/N 30039N2839YTurbo Arrow LLC · Fresno, CABuilt 1979 · S/N 28R-7931218N283CDChesney Style Inc · Belmont, CABuilt 2015 · S/N 2297N283DFrohbieter Alan · Superior, COBuilt 1979 · S/N TK-112N283DDMosier Don · Stanford, KYBuilt 2006 · S/N 1765N283JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2283N283MAAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1975 · S/N TH-669N283RDBengtson Douglas Richard · Woodinville, WABuilt 1981 · S/N 21064320N283SRArtemis Aviation LLC · Mondovi, WIBuilt 2007 · S/N 2682N283TBNance Joseph W · Fort Collins, COBuilt 1977 · S/N U20603956N283TMSpady Jeffrey · Springfield, ORBuilt 1998 · S/N E-3185
Back to AD 2000-23-21