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.

N4888CGoflight Inc · Birmingham, MIBuilt 1979 · S/N 21063656N4888FTaktos Ltd · Corvallis, ORBuilt 1966 · S/N U206-0588N488RHI F Rooks & Associates LLC · Memphis, TNBuilt 1982 · S/N U20606488N488SSale Reported · Friday Harbor, WASale reported, pending cancellationS/N 4140529N488SJDeans Casing Service Inc · Holdenville, OKFirst renewal noticeBuilt 1977 · S/N 414-0959N4895YKeating George W · Fayetteville, ARBuilt 1980 · S/N 21064033N4896KBraxtal LLC · Kingfisher, OKBuilt 1979 · S/N P21000358N4898CPalo Aerocraft Inc · Salem, VABuilt 1979 · S/N 21063659N48AMGwc Air LLC · Madison, ALBuilt 1980 · S/N 414A0609N48VAGeiser Corbin · Little Elm, TXBuilt 1977 · S/N 21061798N48WCBaron Acquisition LLC · Wayne, PABuilt 1981 · S/N TJ-350N4905CAnacapa Capital LLC · Fresno, CABuilt 1979 · S/N 21063664N4909YFremont Airways LLC · Riverton, WYBuilt 1980 · S/N 21064039N490KMRasf414 LLC · Hallandale Beach, FLS/N 414-0399N490MLegacy Ofs Construction LLC · Stillwater, OKBuilt 1983 · S/N EA-390N4911JDarter Lloyd R · Mountain Grove, MOBuilt 1981 · S/N T18803778TN4913JPassmore Stephen B DBA · Lacrosse, WABuilt 1981 · S/N T18803780TN4918UMission Aviation Fellowship · Nampa, IDBuilt 1979 · S/N U20605160N491ACEw Pegasus LLC · Walnut Creek, CAS/N 21063673N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N4922YHowey Aviation LLC · Woodhaven, MIBuilt 1980 · S/N 21064047N4925KAlberts Nelson · Weatherford, TXBuilt 1979 · S/N P21000371N4937JSwirsding David J · Chalfont, PABuilt 1977 · S/N 310R0952N4939YDavidson Dan F · Ozona, TXBuilt 1980 · S/N 21064050N4940KGoves Abram M · Parker, COBuilt 1979 · S/N P21000376N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4946KOrion Technology Group LLC · San Diego, CABuilt 1979 · S/N P21000378N4948AKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1410N4949ASw Air LLC · Denver, COS/N 310R1505N494TSDeep Creek Lake Ventures LLC · Oakland, MDBuilt 1983 · S/N T30300201N495495htsi LLC · Wilmington, DEBuilt 1980 · S/N 414A0487N4950UAerotech Mapping Inc · Las Vegas, NVBuilt 1979 · S/N U20605174N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791TN4960KShuck Drilling Co · Edgar, NES/N P21000383N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180N4981CWatson Michael · Dalhart, TXS/N 21063699N4981KCuriel Gabriel · Oakley, CAS/N P21000390N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146N4994KMenefee Jerry V · Carson City, NVBuilt 1979 · S/N P21000392N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006N499DLCjrr Consulting LLC · Denver, COS/N EA-58N499WWLakes Air LLC · Fargo, NDBuilt 1966 · S/N 411-0161N49AJLvml Real Estate Investments LLC · Rio Grande City, TXBuilt 1978 · S/N P21000059N49ARMoore Thomas A · Kennewick, WAS/N 421B0563N49STHedeen Arnold R · Seattle, WAS/N 21064844N4ADValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 421B0467
Back to AD 75-09-13