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.

N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022N515FVSlowmow Inc · Palestine, TXS/N 414-0410N515RJFroehlich Franz M · Oceanside, CABuilt 1983 · S/N EA-357N515RRHangar 49 Ltd · Wilmington, DEBuilt 1987 · S/N 4608080N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235N515STQ&A Holdings LLC · Elkridge, MDBuilt 1971 · S/N 414-0169N5160JZemnickas William V · Metamora, MIS/N 340-0550N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004N5175JAycock Charles C · Midland, TXS/N 340A0010N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N518BBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 421B0518N518PCJnc Holdings LLC · Mequon, WIBuilt 1977 · S/N 340A0433N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304N519SCCrockett Ryan · Veradale, WAFirst renewal noticeBuilt 1979 · S/N 340A0720N51APConrad Alan B · Las Vegas, NVBuilt 1980 · S/N 340A0970N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602N51CXAerodata LLC · Ann Arbor, MIBuilt 1978 · S/N 340A0533N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306N5203XMike & Critter LLC · Mccall, IDBuilt 1980 · S/N U20605592N5207XGreat Oaks Cdc · Cincinnati, OHBuilt 1962 · S/N 320-1-0107N520ABGolden Eagle Transportation LLC · Lafayette, LABuilt 1979 · S/N 421C0690N5217CHydro Wings Inc · Valle Crucis, NCBuilt 1979 · S/N 21063719N521ADBarringer Aviation LLC · Waxhaw, NCBuilt 1977 · S/N 310R0966N521MMEagle Topflight LLC · Cape Girardeau, MOBuilt 1988 · S/N 4608104N5223AGeneral Plumbing Inc · Walnut Creek, CABuilt 1979 · S/N 21063316N5225VKuhn Chad · Boulder, WYBuilt 1975 · S/N 21060867N5227JSbs Partnership · Henderson, NVBuilt 1980 · S/N 340A1036N5228VDynamite Marketing Inc · Meridian, IDBuilt 1975 · S/N 21060870N522GHQuailridge Aviation LLC · Clarkston, WABuilt 1979 · S/N 21063399N522LMutai Samson Kipruto · Lenexa, KSBuilt 1960 · S/N 57516N523RCS W Air Travel Inc · Parshall, COBuilt 1975 · S/N 21060654N523SHNesher Wings LLC · Phoenix, AZBuilt 1998 · S/N EA-618N5244ZRobinson Levi B · Anchorage, AKBuilt 1981 · S/N U20606085N5249ABrentco Aerial Patrol Inc · Canton, OHBuilt 1985 · S/N P21000840N524CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0522N524MMAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 21063717N5251CSherman Randolph · Beverly Hills, CABuilt 1978 · S/N 310R1526N5251JNarr Craig S · Fort Mohave, AZBuilt 1976 · S/N 310R0813
Back to AD 75-09-13