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.

N2950FSpring Ronald L · London, OHBuilt 1966 · S/N 18257050N2950YJohns Tyler J · Lake George, NYBuilt 1962 · S/N 18253950N2951FHarvey Thomas R · Jacksonville, FLBuilt 1966 · S/N 18257051N2951RRickert Richard A · Thornton, COBuilt 1962 · S/N 310G0151N2952AWeyl George R · Bigfork, MTBuilt 1953 · S/N 30152N2952CToil Oregon Vineyards LLC · Walla Walla, WABuilt 1954 · S/N 30852N2952FFisher Cody · Ennis, TXBuilt 1966 · S/N 18257052N2953QW-Wingmen LLC · Simi Valley, CABuilt 1977 · S/N 28R-7703084N29542Giannakakis Peter J · Monroe, MIBuilt 1973 · S/N 21059866N2954FWestberg Wayne A · Harvey, IABuilt 1966 · S/N 18257054N2954YFasano Garth · Boulder, COBuilt 1962 · S/N 18253954N2955FBoyd John W · Milton, WABuilt 1966 · S/N 18257055N2955YAda Forestry Division · Malvern, ARBuilt 1962 · S/N 18253955N2956YRegistration Pending · Wilmington, DERegistration pendingBuilt 1962 · S/N 18253956N2957CCurrier Dustan · Fairbanks, AKS/N 30857N2957KSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 18053138N2958CSale Reported · Anchorage, AKSale reportedBuilt 1954 · S/N 30858N2958KPionair Inc · ChamBuilt 1980 · S/N 18053139N295AKGlick Farms Inc · Minot, NDBuilt 2003 · S/N 0719N295BPQualitair LLC Trustee · MichelstadtBuilt 1975 · S/N 347570249N295CDSale Reported · ZlinSale reportedS/N 1206N295DLGottschalk Justin R · El Dorado Hills, CABuilt 2007 · S/N 2335N295EC295ec LLC · Eau Claire, WIBuilt 2002 · S/N 0197N295FAStationair Amphib LLC · Jefferson City, MOBuilt 1980 · S/N U20605482N295GTMedina-Solla Edwin O · Carolina, PRBuilt 1966 · S/N 18257799N295RNew Orleans Aviation LLC · Slidell, LABuilt 1981 · S/N 34-8133185N295RJRegistered aircraftBuilt 1983 · S/N EA-381N295SDErf Flight Services LLC · Corpus Christi, TXS/N 4295N2960AGallman Alexander C · Livingston, TXBuilt 1953 · S/N 30160N2961AMerrill Richard C · Chuckey, TNBuilt 1953 · S/N 30161N2961FNilssen Carl J · Cameron, WIBuilt 1966 · S/N 18257061N2961JFrey Jerry P · Fallon, NVBuilt 1979 · S/N T18803581TN2961TMagnumforamen Ppg Aeroadventures LLC · Kalispell, MTBuilt 1966 · S/N 334N2961YGarcia Kale B · Covington, WABuilt 1962 · S/N 18253961N2962AKapsner Mark W · Willow, AKBuilt 1953 · S/N 30162N2962FMcclevey Landon Kole · Dilley, TXBuilt 1966 · S/N 18257062N2962TAviation Days LLC · Ridgefield, CTBuilt 1966 · S/N 335N29631Registered aircraftBuilt 1973 · S/N 21059873N2963CMcmillian Tommy D · Wasilla, AKBuilt 1954 · S/N 30863N2963FConnell Gary A · Anchorage, AKS/N 18257063N2963YMoretti Larry · Monroe, MIBuilt 1962 · S/N 18253963N2964FHunt Stuart J · Lynn Haven, FLBuilt 1966 · S/N 18257064N2964TMallard Aviation LLC · Manchester, NHBuilt 1966 · S/N 337N2964YVanderwel Paul · Woodinville, WABuilt 1962 · S/N 18253964N2965CBauer Joachim · Rhome, TXFirst renewal noticeBuilt 1954 · S/N 30865N2965FFrank Paul R · Waukesha, WIBuilt 1966 · S/N 18257065N2965RSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 34-7970425N2966ACroffut David P · Anchorage, AKBuilt 1953 · S/N 30166N2966FNansen Peter D · Bellingham, WABuilt 1966 · S/N 18257066N2966KMichels LLC · Wasilla, AKBuilt 1980 · S/N 18053140
Back to AD 2000-23-21