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.

N4235CColville LLC · Signal Mountain, TNBuilt 1974 · S/N 414-0534N4237CBreakaway Group Aviation LLC · Franklin, TNBuilt 1974 · S/N 414-0535N423BWFehring William · Sunnyvale, CABuilt 2000 · S/N EA-658N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270N423TMJp Aviation Leasing LLC · Salt Lake City, UTBuilt 1976 · S/N 421C-0107N424JN424 Juliet LLC · Mesa, AZBuilt 1984 · S/N 46-8408019N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266N4255STeton River Flying Service Inc · Rexburg, IDBuilt 1976 · S/N TK-35N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516N4272CKamps Air LLC · Grand Rapids, MIBuilt 1982 · S/N 414A0849N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394N427BDNostra Aeris LLC · Gassville, ARBuilt 1991 · S/N EA528N427DWFlyin Phar LLC · Salt Lake City, UTBuilt 1979 · S/N TK-113N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010N428AJetpropmontana LLC · Cameron, MTBuilt 1986 · S/N 4608031N429GMResendiz Marcelino · Alamo, TXBuilt 1982 · S/N 421C1251N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243N42AMGruhlkey William H · Wildorado, TXBuilt 1979 · S/N EA-29N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922N42BDKristoferson John S · Denton, TXBuilt 1988 · S/N 4608122N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342N42CWHollywood Of The South Flight School Ltd · Decatur, GABuilt 1979 · S/N P21000228N42MWWalker Winston W Trustee · Tucson, AZBuilt 1981 · S/N 414A0680N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387N42SGPolar Star Co · Wilmington, DES/N 4140927N42SMBaron South LLC · Dexter, MOBuilt 1977 · S/N TJ-109N42WBCity Of Mesa Arizona · Mesa, AZBuilt 1981 · S/N P21000667N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011N4308ZMike Victor Yankee LLC · Andover, MABuilt 1983 · S/N T30300183N4312VBaron Be 58 LLC · Essex, MTBuilt 1984 · S/N 46-8408012N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532N4319MSale Reported · Aptos, CASale reportedBuilt 1983 · S/N 46-8408005N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431N4323BBkt Holdings LLC · Mont Belvieu, TXBuilt 1983 · S/N 46-8408009N4323POverspray LLC · Norfolk, NEBuilt 1983 · S/N 46-8408013N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075N432RADirect Entry Holdings LLC · Port Richey, FLBuilt 1979 · S/N 340A0925N43362Plane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 46-8408025N43368Triple 4 Aviation LLC · Martindale, TXBuilt 1984 · S/N 46-8408028N433BPLeverock Richard C · Port Saint Lucie, FLBuilt 1981 · S/N P21000730N43412Registered aircraftBuilt 1984 · S/N 46-8408034N4341NGg And Sg Properties LLC · Seminole, FLBuilt 1984 · S/N 46-8408031N4358MKimt LLC · Iron Mountain, MIBuilt 1984 · S/N 46-8408048N4360VMb Powers Inc · Thompsons Station, TNBuilt 1984 · S/N 46-8408051N4363LVeritas Holdings LLC · Washington, DCBuilt 1984 · S/N 46-8408056N4363MArk 84 LLC · Wilmington, DES/N 46-8408058N4366ZEse Aviation LLC · Houston, TXBuilt 1984 · S/N 46-8408069N436MHaase LLC Series 5 · Henderson, NVBuilt 1990 · S/N EA-512
Back to AD 75-09-13