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.

N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169N16ASStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 421B0317N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101N16EZAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1978 · S/N 310R1277N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130N17040Prather Carl L · Gilroy, CABuilt 1976 · S/N 240N1704LCulver Marc D · Anchorage, AKS/N 10/6155N1716EMccaskill William L · Hampton, VABuilt 1978 · S/N 310R1547N1717SXp Silva Air LLC · Rockaway, NJS/N TJ-53N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251N171DFDkg Motorized Conveyances Inc · Beaverton, ORBuilt 1978 · S/N TJ-155N171PFRegistration Pending · Los Osos, CARegistration pendingBuilt 1980 · S/N EA-164N171RSSeneque USA Inc · West Palm Beach, FLBuilt 1980 · S/N U20605558N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735N1742ECole-Tac LLC · Rapid City, SDBuilt 1978 · S/N 310R1558N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763N174DSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 414A0216N174SFTaylor Thomas R · Lenoir, NCBuilt 1978 · S/N P21000174N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358N175SPN500aa LLC · Wilmington, DES/N 414A0313N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241N177PEPicabo Livestock Co · Picabo, IDBuilt 1979 · S/N P21000334N1781ECallaham John · Broken Bow, OKBuilt 1979 · S/N 310R1571N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744N1786XS K Cattle Co · Manhattan, KSBuilt 1975 · S/N 21060806N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445N17AMFarmdog Aviation LLC · Lafayette, INBuilt 1974 · S/N 414-0524N17ESCrimson Aviation LLC · New York, NYBuilt 1985 · S/N TJ-488N17GPRed River Partners LLC · Edmond, OKBuilt 1979 · S/N TJ-210N17HLRiley Charles S · Littleton, COS/N 421B-0310N17NGParmer Construction Company LLC · Terrell, TXBuilt 1987 · S/N 4608074N1805DDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N EA-233N1806DGold Coast Logistics LLC · St Simons Island, GABuilt 1981 · S/N TJ-364N1807BCloud Nine Corp · Batesville, INBuilt 1981 · S/N EA-234N1807FTurboflyers Inc · Leesburg, VAFirst renewal noticeBuilt 1981 · S/N EA-235N1808QBearspoint LLC · Edmond, OKS/N EA-236N1808RFlorida Fence Corp · Tavernier, FLS/N TJ-366N180BADavis Robert D · Camas, WAS/N 18052419N1811DRegistration Pending · Kennedale, TXRegistration pending, canceledBuilt 1981 · S/N EA-237N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936N1814EErda LLC · Wilmington, DEBuilt 1981 · S/N EA-241N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63N1817AKlinefelter Kristopher J · Phoenix, AZBuilt 1981 · S/N EA-243N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386
Back to AD 75-09-13