OpenAirDocs.org
AD 75-09-13

Registered aircraft · 4,787

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-13')
    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-13')
  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.

N1819MDjb Asset Management LLC · Oakdale, CABuilt 1981 · S/N EA-245N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379N1835SEagles Flying Club Inc · San Francisco, CABuilt 1984 · S/N EA-419N183DAHullmann John · Palo Alto, CABuilt 2003 · S/N 1349N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433N1843LRegistered aircraftS/N TJ-65N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145N18499Austin Aviation LLC · Boise, IDBuilt 1983 · S/N EA-362N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N185MTMarsh Douglas C · Omak, WABuilt 1975 · S/N 18502672N185RAA-T Enterprises Ltd · Three Forks, MTBuilt 1967 · S/N 185-1209N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N189FTeag Leasing LLC · Edmonds, WABuilt 2001 · S/N EA-680N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668N1919LSmith Sydney O · Lithonia, GAS/N 411-0157N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296N1944EHans Construction LLC · Lititz, PAS/N 340A0675
Back to AD 75-09-13