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.

N12000Bear Creek Air LLC · Helena, MTBuilt 1968 · S/N 18259487N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769N12077Crawley Michael P · Penn Valley, CABuilt 1965 · S/N 18255966N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771N1209MShook Steve Trustee · Boulder, COBuilt 1975 · S/N 18264243N120GRStarlight Flight Aerial Tours LLC · Coppell, TXBuilt 1999 · S/N 18280430N120HPRegistration Pending · Lawton, OKRegistration pendingBuilt 2006 · S/N 18281841N120JHC&C Cessna LLC · Baltimore, MDBuilt 1977 · S/N U20603636N120WEHarbor Air Inc · Ann Arbor, MIBuilt 2002 · S/N 18281117N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774N1213LBlack Jesse M Jr · Gainesville, GABuilt 1969 · S/N 18259551N1216MHayward Flying Club · Hayward, CABuilt 1975 · S/N 18264245N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779N1219GRegistered aircraftBuilt 2007 · S/N 18281886N1219PJersey Christopher M · Willis, TXBuilt 1977 · S/N 18265701N121EESheldon Air Service LLC · Anchorage, AKBuilt 1979 · S/N 18503765N121EMRegistration Pending · Austin, TXRegistration pendingBuilt 1966 · S/N 18257784N121FHamilton Wayne J · Mesa, AZBuilt 1956 · S/N 32353N121JMBullet Aviation LLC · Missoula, MTBuilt 2025 · S/N 18283317N121KSCa-C180j LLC · Addison, TXBuilt 1976 · S/N 18052683N121LLWild Blue Air LLC · Homer, AKBuilt 1977 · S/N U20603756N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624N121RAJohnson Owen M III · Seattle, WABuilt 1972 · S/N 18261660N121RDVickery Forest H · Tallahassee, FLS/N 18052053N1220CSky Bear Aviation LLC · Wilmington, DEBuilt 1956 · S/N 33008N1220GGastrock Robert C Trustee · Anchorage, AKBuilt 1973 · S/N U20602232N1220MMcginty Flying Service LLC · Jones, LABuilt 1975 · S/N 18264246N1220RKeywestaero LLC · Wilmington, DEBuilt 2005 · S/N 18281582N12222Thomas John S · Starkville, MSBuilt 2007 · S/N 18282003N1222FVelocity Sport LLC · Cedar Falls, IABuilt 1975 · S/N 18502784N1224PM3 West Inc · Modesto, CABuilt 2004 · S/N 18281357N1225QDupont Larry W · North Hero, VTBuilt 1977 · S/N 18503472N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789N1228MHillsboro Flying Club · Hillsboro, ORBuilt 1975 · S/N 18264247N122DTFine Point Aviation LLC · Carrollton, GABuilt 2000 · S/N 18280908N122JAChase James P · Waco, TXBuilt 2025 · S/N 18283320N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533N122TTEveraert Filip L · Midland, MIBuilt 1974 · S/N 18262858N122VCTurner Terrance A · Anchorage, AKBuilt 1973 · S/N 18502203N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094N1231FRegistration Pending · Wasilla, AKRegistration pendingBuilt 1975 · S/N 18502793N1232FLloyd Land Plane I LLC · Brighton, COBuilt 1975 · S/N 18502794N1233BSutton Aircraft Salvage LLC · Palmer, AKS/N 51215N1233FFlyboyz LLC · Bourbon, MOS/N 182-61270N1233MFrench Rollie T · Vermillion, SDBuilt 1975 · S/N 18264251N1233WDouble Crown Investments LLC · Earlsboro, OKBuilt 1970 · S/N 18260263N1234FSkydive New Hampshire LLC · Moab, UTFirst renewal noticeS/N 33444N1234YDe Jong Thomas · Buckeye, AZBuilt 1980 · S/N 18503944
Back to AD 75-16-01