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.

N1236FPitcher Michael C · Mancelona, MIS/N 18502796N1236MRutherford Dustin · Simi Valley, CABuilt 1975 · S/N 18264252N1237Fraser Mark L · Fairfield, CABuilt 1980 · S/N 18504021N1239FValpey R Wesley Jr · Medford, MEBuilt 1975 · S/N 18502799N1239MMonarch M Miller · Ocala, FLBuilt 1975 · S/N 18264254N123ARRullan Alberto · Adjuntas, PRBuilt 1998 · S/N 18280232N123DBN123db LLC · Madison, NJFirst renewal noticeBuilt 1973 · S/N 18262088N123DLNiche Advertising Solutions Inc · Statesboro, GABuilt 1969 · S/N 18259340N123EPFalkenberg Randy J · Edmonson, TXBuilt 1976 · S/N 185-03216N123GLAir Care Leasing LLC · Lamar, COBuilt 1973 · S/N 18261902N123KLWings Over The Rockies LLC · Wittmann, AZBuilt 1977 · S/N 18265746N123LJRegistered aircraftBuilt 1965 · S/N 18051526N123TMJaars Inc · Waxhaw, NCS/N U20601768N123TZSouthside Truck And Trailer Inc · San Antonio, TXBuilt 2004 · S/N 18281327N123UPApache Underground And Excavating LLC · Lakeside, AZBuilt 1969 · S/N 18259985N123VJKopp Daniel D · Buckeye, AZBuilt 1965 · S/N 18256102N123WGThornhill Shaun · Greenville, OHBuilt 1963 · S/N 18254997N1240MElk Creek Investments LLC · Helena, MTBuilt 1975 · S/N 18264255N1242MHenninger Bradley J · Green Cove Springs, FLS/N 18264256N1243MRegistered aircraftBuilt 1975 · S/N 18264257N1245BPositive Flight LLC · San Ramon, CABuilt 1975 · S/N 18264060N1245SMccain Michael E · Sun Valley, NVBuilt 1976 · S/N 18264814N1247SShurma Ramesh · Hayward, CABuilt 1976 · S/N 18264816N1248EBoling Derek · Paragould, ARBuilt 2005 · S/N 18281590N1248SBodolay John M · Fredericksburg, VABuilt 1976 · S/N 18264817N1249SClemans Alan J · Guymon, OKBuilt 1976 · S/N 18264818N124BSLeair LLC · Eufaula, ALBuilt 2004 · S/N 18281390N124EFGuerrer Daniel S · Redondo Beach, CABuilt 1998 · S/N 18280315N124KChicken Hawk Aviation LLC Series 2 · Waxahachie, TXBuilt 1975 · S/N 18263803N124LRWilson David J · Palmer, AKBuilt 1970 · S/N 18501639N124SKAgarwal Sanjai K · Monroe, NJBuilt 2025 · S/N 18283304N124UAKagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18503022N124WHHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N U20605355N124WJSessions Thomas Eric Trustee · Huffman, TXBuilt 2004 · S/N 18281475N124WMDenton James Manley Jr · Cabot, ARBuilt 2016 · S/N 18282431N124WNTemple Steve D · Superior, MTBuilt 1972 · S/N U206-01832N1250MBlakley John · Cascade, IDBuilt 1963 · S/N 18051213N1250SNew Oasis Market Inc · Blacksburg, VABuilt 1976 · S/N 18264819N1250WScherff Lewis H Trustee · Inver Grove, MNBuilt 1964 · S/N 18051429N1251BJagow Charles Philip · Fairbanks, AKBuilt 1966 · S/N 18051756N1251DErjoaero LLC · Stuart, FLBuilt 2007 · S/N 18282023N1251SPt Air LLC · Madison, WIBuilt 1976 · S/N 18264820N1252EStedje Timothy M · Gruver, TXBuilt 1999 · S/N 18280580N1252MNyquist David · Boulder, COBuilt 1975 · S/N 18264259N1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKS/N 18503473N1253SHale Jeffrey D · Reno, NVBuilt 1976 · S/N 18264822N1254SStewart Donald K · Holbrook, MABuilt 1976 · S/N 18264823N1255MCammack Lockwood P · Mount Pleasant, TXFirst renewal noticeBuilt 1975 · S/N 18264261N1255VHanson Lanny Lane · Polson, MTBuilt 1974 · S/N U20602540N1256SBrant P Rouse Dds Plc · Tahlequah, OKBuilt 1976 · S/N 18264825
Back to AD 75-16-01