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.

N58TTBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 21062998N58VBBeckman Donald A · Rostraver Township, PABuilt 1980 · S/N TJ-260N59007Hang On LLC · Montrose, COBuilt 1973 · S/N 21060014N59008Davis Burton D · Jefferson, IABuilt 1973 · S/N 21060015N59011Nelson Albert N III · Baytown, TXBuilt 1973 · S/N 21060018N59041Edwards Aviation & Consulting LLC · Broken Arrow, OKBuilt 1973 · S/N 21060044N59045Air-Zancada Inc · Wilmington, DEBuilt 1973 · S/N 21060046N59049Scarry David Charles · San Luis Obispo, CABuilt 1973 · S/N 21060049N590FMTrrek Enterprises LLC · Sunriver, ORBuilt 1966 · S/N 320D0095N5910MCross Country Well Service LLC · Farmington, NMS/N 340-0067N5916MQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 402B0365N59173Vogelgesang Randy · Gardnerville, NVBuilt 1973 · S/N 21060141N59258Energy Roofing Technology Se LLC · Lake City, FLS/N 21060180N59286Staley Ronald L · Lebanon, ORBuilt 1974 · S/N U20602643N59294Cornucopia Investment Group LLC · South Jordan, UTBuilt 1974 · S/N U20602645N592GCFogelson Robert A · Tillamook, ORBuilt 1972 · S/N 340-0152N5931MSteven F Danz LLC · Encino, CABuilt 1972 · S/N 340-0071N5938MKarlen John R · Boring, ORS/N 340-0074N594BVJmak Corp · Seymour, TNBuilt 1978 · S/N 340A0440N594DSJsb Aviation LLC · Harrison, ARBuilt 1980 · S/N TJ-318N595LTN595lt LLC · Edwards, COS/N P21000008N595XXHolladay Logan · Salt Lake City, UTFirst renewal noticeBuilt 1979 · S/N TJ-189N5962MKitov Resources Corp · Shorewood, WIS/N 421B0205N5967MN5967m LLC · Chantilly, VAS/N 421B0210N5975JFreeland Christopher G · Brownwood, TXS/N 414-0028N5988MSaltzer Eric · Somerton, AZBuilt 1972 · S/N 421B0231N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003N598DMAirswiss Inc · Wilmington, DEBuilt 1979 · S/N 402C0114N5996MMedcare Emergency Medical Services Inc · Mcallen, TXBuilt 1972 · S/N 421B0334N59ABates Roger · Palm Beach Gardens, FLBuilt 1978 · S/N 21062509N59EMFletcher Marvin L · Fargo, NDBuilt 1984 · S/N 46-8508022N59KJSpike LLC · Cheyenne, WYBuilt 1993 · S/N EA-549N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5BPTippettsolutions LLC · Fort Mill, SCBuilt 1980 · S/N TJ-315N5CGSamair LLC · Blackshear, GABuilt 1979 · S/N 340A0751N5CHHartshorn William T · Tucson, AZBuilt 1968 · S/N 421-0113N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5ERMill Direct Textiles LLC · Rollinsford, NHBuilt 1982 · S/N T30300137N5HSRose Raymond P · San Diego, CABuilt 1962 · S/N 320A0026N5JKLizard Two LLC · Wilmington, DEBuilt 1981 · S/N TJ-295N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N5NNRkgrier LLC · Beckley, WVS/N 421C0446N5PAFinal Design Group LLC · Hurricane, UTBuilt 1981 · S/N EA-251N5ZTAllen Airplane LLC · Durango, COBuilt 1973 · S/N 414-0477N60018Moreno & Nelson Construction Corp · Walla Walla, WABuilt 1973 · S/N U20602002N6006NFraser Shane · San Marcos, TXBuilt 1978 · S/N 21062875N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025N600PAHeaven'S Landing Realty Inc · Clayton, GABuilt 1980 · S/N TJ-250N600THN600th LLC · Fredericksburg, VABuilt 1981 · S/N 414A0668
Back to AD 75-09-13