AD 75-09-06

Registered aircraft · 1,624

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-09-06')
    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-09-06')
  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.

N1780RDoellefeld Jason T · Langsville, OHBuilt 1974 · S/N 18502498N1789Hill Sheldon S · Minot, NDFirst renewal noticeBuilt 1974 · S/N 18502342N178VVStanley Bryan Dale · Paso Robles, CABuilt 1967 · S/N 185-1232N1790RBlack Dog Holding Inc · Pleasant Valley, NYS/N 18502506N1792REcho Matrix LLC · Bentonville, ARBuilt 1974 · S/N 18502508N1795RBroussard Kenneth John · Lafayette, LABuilt 1974 · S/N 18502511N1798RSedwick Jack D III · Anchorage, AKBuilt 1974 · S/N 18502514N1799RAir Support 1 Inc · Middletown, DEBuilt 1974 · S/N 18502515N17SRNcsb LLC · Anchorage, AKBuilt 1974 · S/N 18502424N1802RMontaska Management Inc · Anchorage, AKBuilt 1974 · S/N 18502518N1805Mcgarry Patrick L · Payson, AZBuilt 1972 · S/N 18502038N18118Bokman Charles J III · Athol, IDBuilt 1977 · S/N 18503328N1812RDriskell James P · Anchorage, AKBuilt 1974 · S/N 18502527N1815ROsprey Island Lodge Inc · Eagle River, AKBuilt 1974 · S/N 18502530N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531N1820RBarkhimer James C · Iraan, TXBuilt 1974 · S/N 18502535N1821RHoward Todd R · Minneapolis, MNBuilt 1974 · S/N 18502536N1822ROney Tony K · Anchorage, AKBuilt 1974 · S/N 18502537N1823RJones Alfred J · Friendsville, PABuilt 1974 · S/N 18502538N1825QCree William H III · Long Beach, CABuilt 1977 · S/N 18503492N1825RKincaid James B · Wasilla, AKBuilt 1974 · S/N 18502540N1831RC & D Aviation LLC · Brentwood, CABuilt 1974 · S/N 18502546N1836RBc Properties LLC · Anchorage, AKS/N 18502551N1839RBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 18502554N1841RPatton Ronald V II · Keizer, ORBuilt 1974 · S/N 18502556N1847RNugent Properties LLC · Wasilla, AKFirst renewal noticeBuilt 1974 · S/N 18502562N1848QHartley Paul · Bellevue, WABuilt 1977 · S/N 18503493N1848RTallman Dale C · Wasilla, AKBuilt 1974 · S/N 18502563N185Ellison Jeremy Trustee · Dayton, NVBuilt 1974 · S/N 18502582N18500Thompson Dennis E · Anchorage, AKBuilt 1977 · S/N 18503305N18521Island Air LLC · Eagan, MNBuilt 1979 · S/N 185-03812N1852RHartman Craig T Trustee · Chugiak, AKBuilt 1975 · S/N 18502567N1856RRich Gary L · Anchorage, AKBuilt 1974 · S/N 18502571N185ABKinneen Simon N · Nome, AKBuilt 1981 · S/N 18504348N185ADDurrett Aviation LLC · Anchorage, AKBuilt 1978 · S/N 18503576N185AEDbl LLC · Hays, KSBuilt 1973 · S/N 18502125N185AFTanada Lake Lodge LLC · Grand Junction, COBuilt 1973 · S/N 18502236N185AHHattenburg Scott L · Chugiak, AKBuilt 1981 · S/N 18504263N185AJKelly Christopher · Lantana, TXBuilt 1978 · S/N 18503560N185AKFrench Joddy D · Wasilla, AKBuilt 1976 · S/N 18503006N185AMLanham Douglas S · Santa Fe, NMBuilt 1974 · S/N 18502529N185AQ2f Trade LLC · Collinsville, TXS/N 18502440N185ARWattum Investments LLC · Kodiak, AKBuilt 1969 · S/N 1851464N185ASAdventure Bound Seaplanes Inc · Tower, MNBuilt 1976 · S/N 18502950N185AVRemote Access Aviation LLC · Saint Albans, VTBuilt 1977 · S/N 18503434N185AWVaughn Aviation LLC · Lowell, ARS/N 18504227N185AZHeard Jesse H · Lewiston, IDBuilt 1976 · S/N 18503112N185BGibney Michael L · Bigfork, MTS/N 18503336N185BABerk Aviation LLC · Phoenix, AZBuilt 1978 · S/N 18503498N185BBBeiter Paul R · Ellensburg, WABuilt 1977 · S/N 18503449
Back to AD 75-09-06