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.

N4372BTyler Hendry Dds Inc · Glendale, CABuilt 1984 · S/N 46-8408083N4372EPad Aviation LLC · New Castle, DEBuilt 1984 · S/N 46-8408085N4372LSteen Douglas S · Cresson, TXBuilt 1984 · S/N 46-8408087N4376APeavy Ricky Tod · Gainesville, GABuilt 1984 · S/N 46-8508004N4377ATebeaux William Jene · College Station, TXBuilt 1984 · S/N 46-8508008N4380DLivengood Leasing Co LLC · Mesa, AZBuilt 1985 · S/N 46-8508045N4380S9791m LLC · Tacoma, WABuilt 1984 · S/N 46-8508020N4386NFreedom Airplane Jv 1 LLC · Pensacola, FLBuilt 1985 · S/N 46-8508039N4387DTravel Direct LLC · Montevideo, MNBuilt 1985 · S/N 46-8508040N4388MMalibu 88mike LLC · Duncanville, TXBuilt 1985 · S/N 46-8508047N438APWhiskey 340 LLC · Tucson, AZBuilt 1977 · S/N 340A0438N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274N43911Scud Runner LLC · Cape Coral, FLBuilt 1985 · S/N 46-8508059N4391EN4391e LLC · Scottsdale, AZBuilt 1985 · S/N 46-8508054N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224N43CPMountain View Industries LLC · Missoula, MTBuilt 1979 · S/N P21000398N43DAAero Management Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 340A0112N43KTTowles Michael D · Corona Del Mar, CABuilt 1993 · S/N E-2808N43KYPinto Carlos Eduardo · Tucson, AZBuilt 1972 · S/N 21059563N43MEEvans Matthew B · Granbury, TXBuilt 1978 · S/N P21000046N43MRFlight Contract Services Inc · Las Vegas, NVS/N 414A-0016N43QCAviation LLC · Kalispell, MTBuilt 1984 · S/N TJ-467N4402JBruton Paul · El Campo, TXBuilt 1980 · S/N T18803736TN440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401N440LJByington William · Minden, NVS/N 421C0299N4414RKirk Ledoux · Stanwood, WABuilt 1979 · S/N U20605111N441TPUnited Contractors Inc · Costa Mesa, CABuilt 1978 · S/N 414A0057N441TTSunbird Airlines Inc · San Juan, PRBuilt 1981 · S/N 402C0441N4421RJ & B Aircraft Leasing LLC · Lufkin, TXBuilt 1985 · S/N 46-8508051N4422NValiair Lc Trustee · Casper, WYBuilt 1978 · S/N P21000099N4428CPayne Jeffrey C Trustee · Stockton, CABuilt 1980 · S/N EA-59N4429LShingebiss LLC · Independence, ORBuilt 1982 · S/N 21064647N442CCRaymond Andrew A · Crescent, IAS/N 414A0483N442FMHogan Quinn H Trustee · Milwaukee, WIBuilt 1979 · S/N 414A0303N443RSalinas Construction Technologies Ltd · Pleasanton, TXS/N 414-0361N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567N44463Sabine Financial Services Inc · Wilmington, DEBuilt 1988 · S/N 4608113N444ATCore Aviation LLC · Dayton, OHS/N 421B0897N444BGMitchell Aviation LLC · Mitchell, SDBuilt 1980 · S/N 421C0893N444BSSiemens Christopher L · Seminole, TXBuilt 1978 · S/N 21062823N444BZWilliams Allen G Jr · Fort Worth, TXBuilt 1974 · S/N 414-0490N444DMGosnell Josh W · Richards, TXBuilt 1974 · S/N 414-0522N444DTBagdasarian Walter DBA · El Cajon, CAS/N 4608008N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686N444FCCentric It Resources LLC · Loomis, CABuilt 1981 · S/N EA-257N444HTTaktos Ltd · Corvallis, ORBuilt 1973 · S/N 310Q0739N444JMPeck Joseph A · Pound Ridge, NYBuilt 1976 · S/N 340A0280N444KTHangar G-1 Aviation Partners LLC · Los Olivos, CABuilt 1981 · S/N 340A1235N444KWRaw Racing Inc · Puyallup, WAS/N 340A0241N444LSTaa Property LLC · Lake Wales, FLBuilt 1973 · S/N 414-0460
Back to AD 75-09-13