AD 75-01-07

Registered aircraft · 2,118

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-01-07')
    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-01-07')
  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.

N2020WMidland Mist Inc · Midland, GABuilt 1966 · S/N D-8077N2021EEagle Home Medical Corp · Roanoke Rapids, NCBuilt 1978 · S/N D-10158N20224Obie Aviation LLC · Rogers, ARBuilt 1978 · S/N D-10159N2022WStadelmann Joseph P · Milton, MABuilt 1965 · S/N D-7968N2024GPerry Scott D · Hood River, ORBuilt 1978 · S/N D-10162N2024KB2s Aviation LLC · Billings, MTBuilt 1978 · S/N D-10164N2024VWhiskey Tango Flyers Inc · Middletown, DEBuilt 1978 · S/N D-10165N2024WMunn Jeffrey R · Auburn, NYBuilt 1966 · S/N D-8078N2028AWallender Timothy J · Manhattan Beach, CABuilt 1969 · S/N D-9026N2028PFerm Michael D · Fort Calhoun, NEBuilt 1978 · S/N D-10167N2029DVictory Auto Sales LLC · Memphis, TNFirst renewal noticeBuilt 1978 · S/N D-10168N202JRiche Aviation LLC · Baton Rouge, LABuilt 1964 · S/N D-7418N20307N20307 LLC · Trabuco Canyon, CABuilt 1978 · S/N D-10174N20318Siegfried Thelma Trustee · Downers Grove, ILBuilt 1978 · S/N D-10173N2032EOhio Air Partners LLC · Chardon, OHBuilt 1978 · S/N D-10170N2035PHubert John P · Austin, TXBuilt 1978 · S/N D-10176N2037WGregs Crop Care Co · Wilbur, WABuilt 1965 · S/N D-7980N2038UWorld Aero Space Ltd · Henderson, NCBuilt 1978 · S/N D-10180N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181N2041WJimenez John D · San Antonio, TXS/N D-7982N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185N20478V35b Bonanza LLC · Temecula, CAS/N D-10194N2047WKapusta Marian · Clearwater, FLBuilt 1965 · S/N D-7986N2048WTripi Mark DBA · Parkersburg, WVBuilt 1965 · S/N D-7987N2049NAdvanced Aviation LLC · New Century, KSBuilt 1978 · S/N D-10190N2049WHufford P Thomas Trustee · San Diego, CABuilt 1965 · S/N D-7985N2050ZPong William Robert · San Mateo, CABuilt 1978 · S/N D-10193N2051KSocio Aviation Services LLC · Benton, KYBuilt 1978 · S/N D-10198N2053WOem Products Inc · Oklahoma City, OKBuilt 1965 · S/N D-7990N2054NHampton Todd J · Plainfield, INBuilt 1978 · S/N D-10196N2054WVerran Clinton T · Rochester Hills, MIBuilt 1965 · S/N D-7991N2055UR & D Aircraft LLC · Port Orange, FLBuilt 1978 · S/N D-10204N20572Shaw Brian · Meadville, PABuilt 1979 · S/N D-10247N2058WSweet Fred A · Loves Park, ILS/N D-8192N2059ABuerge Scott · Nevada, MOBuilt 1978 · S/N D-10202N2059WMorgan Jeffrey B · Edgewater, FLBuilt 1965 · S/N D-7993N205PMHochstetler Allen D · Fairfield, CABuilt 1964 · S/N D-7599N20603Burlington Air Center Inc · Burlington, WIBuilt 1978 · S/N D-10207N2060WBreskman David G · King Of Prussia, PABuilt 1965 · S/N D-7994N2062BWalker Marshall E · Lancaster, SCBuilt 1979 · S/N D-10205N2062WMichalka James R · Portage, MIBuilt 1965 · S/N D-7996N20654Spatz Phillip D · League City, TXBuilt 1979 · S/N D-10212N2065YAbel Instruments Inc · Riviera Beach, FLBuilt 1979 · S/N D-10211N2066NBobo Kenneth · Auburndale, FLBuilt 1979 · S/N D-10215N2072WNewsome Jeff · Blackwell, OKBuilt 1965 · S/N D-8001N2073WPlowden William E Jr · Shelby, NCBuilt 1965 · S/N D-8003N2075WCooper Jeffrey B · Eagle River, AKBuilt 1965 · S/N D-8005
Back to AD 75-01-07