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.

N55RBGots To Go LLC · Wilmington, DEBuilt 1975 · S/N 340A0015N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586N560BBSednal Enterprises · Los Gatos, CABuilt 1994 · S/N EA-562N562DGB2d LLC · Wickenburg, AZBuilt 1976 · S/N 21061684N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347N566AGarrett Flying Service Inc · Danbury, TXBuilt 1965 · S/N 320D0062N567DEclipse Inc · Sharon Springs, KSBuilt 1980 · S/N P21000665N567DTCenturion Aviation Inc · Kalispell, MTBuilt 1978 · S/N 21062856N567KCWelch Darrnell M · Hillman, MIBuilt 1987 · S/N 4608071N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221N568HBKurreck Tim R · Caldwell, IDBuilt 1977 · S/N 21061864N568TWWestray James H · Gainesville, GABuilt 1981 · S/N 340A1252N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222N56CMFamily Practice Associates LLC · Ulysses, KSS/N 310R1422N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847N56GLRainosek Kevin · Granbury, TXBuilt 1994 · S/N EA-572N56HDouble D International LLC · Miami, FLBuilt 1977 · S/N 414-0941N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804N56VPGoulette Bryan · Fort Worth, TXBuilt 1961 · S/N 320-0036N5701XCoan Mark A · Berthoud, COBuilt 1961 · S/N 320-0001N5714XKulon Andrew · Wyanet, ILS/N 3200014N5716JTaos Sky Flight School LLC · El Prado, NMBuilt 1969 · S/N P20600616N5716XFlanegan Charles E Jr · Jonesboro, GABuilt 1961 · S/N 320-0016N5721XRichardson John L · Anchorage, AKS/N 320-0021N5729MN5729m LLC · Coral Springs, FLBuilt 1972 · S/N 340-0038N5731XLife Is Flying Inc · Deerfield Beach, FLBuilt 1961 · S/N 320-0031N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643N5746X300 Series Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 320-0046N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065N5768JHaag Walter G · Fall City, WABuilt 1971 · S/N 21059468N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037N5769XHagemeier Justin · Memphis, TNBuilt 1961 · S/N 320-0069N5770MBallard Aviation Inc · Newton, KSFirst renewal noticeBuilt 1968 · S/N 310P0070N5779XDirigo Aerospace Solutions LLC · Sumner, MES/N 320-0079N577CDSeger Properties Ltd · Fort Loramie, OHBuilt 1969 · S/N P20600609N577KBDavid A Bush Inc · Hanford, CABuilt 2001 · S/N EA-668N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108N5780XWilton William H · Kailua Kona, HIBuilt 1961 · S/N 320-0080N5788XMcmahan William K · Sandy Valley, NVBuilt 1962 · S/N 320-0088N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093
Back to AD 75-09-13