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.

N5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 340A0410N5325YBeehive Telephone Co Inc Nevada · Lake Point, UTBuilt 1980 · S/N 21064164N5328JKahler Automation Corp · Fairmont, MNBuilt 1977 · S/N 340A0412N532CHall Brian · Yuma, AZBuilt 2002 · S/N EA-691N532CHWhedbee Donald Justin · Conroe, TXBuilt 1980 · S/N P21000501N532EBJeb Air LLC · Waverly, OHBuilt 1980 · S/N 414A0440N5337CMarc Inc · Bolton, MSBuilt 1978 · S/N 310R1543N5337YClement Aviation Inc · Tea, SDBuilt 1980 · S/N 21064171N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805TN533ACEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1978 · S/N 414A0103N533STGentry Air LLC · Orlando, FLBuilt 1978 · S/N 414A0034N533WPJacobs Aviation LLC · Mt Juliet, TNS/N 340A0328N5340GLegal Limit Motor Sports LLC · Anderson, CAS/N 340A0421N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173N5346JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1977 · S/N 340A0419N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244N535MESky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N P21000345N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391N5365XSale Reported · Greeley, COSale reportedBuilt 1973 · S/N 414-0387N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185N536JSShoffner James P Jr · Denver, COBuilt 1984 · S/N EA-418N5370JJaaam Skyline Inc · Middletown, DEBuilt 1975 · S/N 421B0920N5371JColeair LLC · Lewes, DEBuilt 1975 · S/N 421B0921N5372CFlc Aviation LLC · Dyersburg, TNBuilt 1978 · S/N 414A0110N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408N5394XL K Hollenbeak Logging Inc · Hayfork, CABuilt 1980 · S/N U20605710N5395VCortez Flying Service Inc · Cortez, COBuilt 1975 · S/N 21060930N53AUJoachim Peter · Grafton, WIBuilt 1974 · S/N 340-0356N53MG28 Lv LLC · Las Vegas, NVBuilt 1980 · S/N 421C0909N53MJAviation Hangar Foam Specialists LLC · Tucson, AZBuilt 1979 · S/N 421C0667N53RRTwo Romeos LLC · Pasco, WAS/N 421A0029N53WTRock House LLC · Keizer, ORBuilt 1980 · S/N 414A0533N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414N5401XBarbera Frank M · Edgewood, NMBuilt 1980 · S/N U20605717N5402AHodge Marcus · Mansfield, LABuilt 1985 · S/N P21000851N5404WBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000683N5405AN5405a LLC · Beverly Hills, CABuilt 1985 · S/N P21000852N5409GRichland Aviation Inc · Sidney, MTS/N 404-0028N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198N540CEEverel Airborne LLC · Sandia Park, NMBuilt 1985 · S/N P21000853
Back to AD 75-09-13