AD 75-16-01

Registered aircraft · 17,795

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:75-16-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-01')
  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.

N1257P812 Aviation LLC · Salem, INBuilt 2022 · S/N 18283193N1257SKidd Bryce · Clovis, NMBuilt 1976 · S/N 18264826N12580White River Ag Spraying Llp · Newport, ARBuilt 1964 · S/N 18051458N125JABillmans Inc · Cut Bank, MTBuilt 2005 · S/N 18281527N125KTRustair Inc · Anchorage, AKBuilt 1977 · S/N 18503494N125LGWheat Travis W · Henderson, NVS/N 18280070N125MWMishler Kenneth C · Lawrence, KSBuilt 1973 · S/N 18262211N125PBEvergreen Financial Investments LLC · Wayzata, MNBuilt 1977 · S/N 18265348N125SLSlingshot Aviation LLC · Chandler, AZBuilt 2003 · S/N 18281253N125TLPease Lynn A · Elizabeth, ILS/N 18255291N125WAHorton Kelly · Hollis, OKBuilt 1975 · S/N 18263594N125WWRegistered aircraftBuilt 1998 · S/N 18280348N1261SRed Arrows Aviation LLC · Lakeway, TXBuilt 1976 · S/N 18264829N1262MRtw Aviation LLC · Fort Lauderdale, FLFirst renewal noticeBuilt 1975 · S/N 18264265N1262SSopatyk Brian D · Boise, IDBuilt 1976 · S/N 18264830N1263SAlabama Law Enforcement Agency · Montgomery, ALBuilt 1976 · S/N 18264831N1265SColeman Douglas · Ocean Springs, MSBuilt 1976 · S/N 18264833N1266SBarton Jonathan E · Tehachapi, CABuilt 1976 · S/N 18264834N12675Van Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18282026N1267SWhitmore James W · Grass Valley, CABuilt 1976 · S/N 18264835N1268MHuffer Tyle · Kenansville, NCBuilt 1975 · S/N 18264266N1269MEagle High Properties LLC · Calhoun, LABuilt 1975 · S/N 18264267N1269SMriaudio Inc · Carlsbad, CAS/N 18264837N126AKRohl Shirley J · Anchorage, AKBuilt 1957 · S/N 32772N126JCGebler Laurence W · Ellerbe, NCBuilt 1979 · S/N 18267134N126MPSorensen P Grahame · Salt Lake City, UTBuilt 1974 · S/N 18262809N126MSNance Cattle Co · Birney, MTBuilt 1964 · S/N 18051373N126SWollaston Dean E · Hazel Green, WIBuilt 1956 · S/N 33285N1272SAfrican Parks Aviation Inc Trustee · Cheyenne, WYFirst renewal noticeBuilt 1976 · S/N 18264840N1274MGarner Tom Trustee · Agua Dulce, CABuilt 1975 · S/N 18264271N1274SDiamond E Electrical Services LLC · Bryant, ARBuilt 1976 · S/N 18264842N1278SSac Exec LLC · Sacramento, CABuilt 1976 · S/N 18264846N1279MSturdy Wings Aviation LLC · Mcpherson, KSBuilt 1975 · S/N 18264272N1279SCavu Aviation LLC · Haiku, HIBuilt 1976 · S/N 18264847N127CFGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18282027N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234N127RLSkylane Of Ohio LLC · London, OHS/N 18262910N127SLGulf Coast Helicopters Inc · Pearland, TXBuilt 2003 · S/N 18281256N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629N127VCSmith Von T · Chelan, WABuilt 1967 · S/N 18258041N1281SChief Cornerstone LLC · Billings, MTBuilt 1976 · S/N 18264849N1282FRainbow River Lodge Aviation LLC · Alpine, UTS/N 18502806N1284TWhite Wayne A · Loyalton, CABuilt 1959 · S/N 52016N1285FWill Rittner E · Sevierville, TNBuilt 1975 · S/N 18502809N1286FTaylor Aviation Inc · Mazama, WAFirst renewal noticeBuilt 1975 · S/N 18502810N1288SFrench Oil Co · Midland, TXBuilt 1976 · S/N 18264855N128BWRodriquez Roy L DBA · Martin, TNBuilt 1969 · S/N 18260080N128JRMorris Dylan L · Garden Plain, KSBuilt 1976 · S/N 18264785N128SWRegistered aircraftBuilt 1966 · S/N 18051699N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991
Back to AD 75-16-01