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.

N117BDHall Alan Ray · Willow Park, TXBuilt 2017 · S/N 18283024N117FFRoaming Homes Inc · South Saint Paul, MNBuilt 1975 · S/N 18264383N117PHR & R Leasing LLC · Fargo, NDBuilt 1977 · S/N 18265492N117SDLong Joseph F · Carroll, OHS/N 18280926N117TTMustang LLC · Wilsonville, ORFirst renewal noticeBuilt 1978 · S/N 18266432N1180BAom Aircraft LLC · Wilmington, DEBuilt 1953 · S/N 30115N1182AAero-Flyte Of Pomona Inc · Upland, CABuilt 1975 · S/N 18264009N1183MHess Darren Michael · Wenatchee, WABuilt 2007 · S/N 18281911N1185Wahlers Richard H · Meridian, IDBuilt 1971 · S/N 18501931N1185TBelanger Ernest E · Wasilla, AKS/N 18501971N1186TMap Aviation LLC · Coral Gables, FLBuilt 2007 · S/N 18281879N11896Mcginty Flying Service LLC · Jones, LABuilt 1977 · S/N 18052921N1189RM9 180 LLC · Delhi, LAS/N 30698N118ARegistration Pending · Shasta, CARegistration pendingBuilt 1977 · S/N 18503339N118HRDieschbourg Thomas Arthur · Glenview, ILBuilt 1983 · S/N 18268332N118PTBengal Aviation LLC · Ridgeland, MSBuilt 2004 · S/N 18281393N118RABroken Aero Inc · Dunnellon, FLBuilt 1967 · S/N 18051935N118SCLeathers Charles M · Silverthorne, COBuilt 1981 · S/N 18268069N118SLJoe Morten & Son Inc · South Sioux City, NEBuilt 2003 · S/N 18281244N1190DCds Enterprise Group LLC · Ionia, MIBuilt 2000 · S/N 18280694N1191QCameron Schoessler Aviation LLC · Bliss, IDBuilt 1975 · S/N U20602862N1191VWilmarth Rebecca C · Red Devil, AKBuilt 1974 · S/N U20602506N1192SHill Don E · Highlands, TXBuilt 2007 · S/N 18281881N1193RState Of Wisconsin · Madison, WIBuilt 2007 · S/N 18281882N1194QKirkpatrick Jason · Mosca, COBuilt 1975 · S/N U20602864N1194RBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 18281894N1194WPm Technology And Leasing LLC · Inver Grove, MNFirst renewal noticeBuilt 2007 · S/N 18281906N1195MBrown Alan J · Cheyenne, WYBuilt 1975 · S/N 18264240N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N1197MSholer Jon R · Battle Ground, WABuilt 1975 · S/N 18264241N11995Russell Ricky · Montrose, ARS/N 18263974N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119JLMayo Clive S · Palmetto Bay, FLBuilt 1973 · S/N 18262575N119LSMarsair LLC · Franklin, WIBuilt 2002 · S/N 18281119N119RKHtv Music Co · Franklin, TNBuilt 1972 · S/N 18261574N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252N11FRMosley John E · Jackson, MSBuilt 1971 · S/N 18260761N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484N11JESky Vista LLC · Macon, GABuilt 1974 · S/N 18263240N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086N11WHT T Aero LLC · Pauls Valley, OKBuilt 1956 · S/N 33447N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498N11YZHuggins David R · Carmichael, CABuilt 1970 · S/N 18260401
Back to AD 75-16-01