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.

N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083N60ZWGleitsmann Lars · Anchorage, AKBuilt 1967 · S/N 87/6267N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715N6103RAta Auto Service Inc · Wilmington, NCBuilt 1965 · S/N T210-0003N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604N6128ROhop Robert D · Jones, OKBuilt 1965 · S/N T210-0028N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508N6131RAir LLC · Salem, ORS/N T210-0031N6131XGv Air Inc · Medford, ORS/N 310R1296N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909N6151QNitro Zeus Inc · Wilmington, DEBuilt 1967 · S/N 320F-0001N6151UMccall John A · Grapeland, TXBuilt 1985 · S/N 21064914N6151YBulloch Troy P · Cedar City, UTS/N 21064269N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696N6155RPlane + Simple LLC · Salt Lake City, UTBuilt 1965 · S/N T210-0055N6155YAl & Zal Corp · Wilmington, DEBuilt 1981 · S/N 21064271N6156QGem State Transportation Inc · Hamilton, MTBuilt 1967 · S/N 320F-0006N6159ULaw Office Of Vincent G Rieger · Kalispell, MTBuilt 1985 · S/N 21064927N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019N6162RSmjd LLC · Penrose, COBuilt 1965 · S/N T210-0062N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818N6168NRegistered aircraftBuilt 1978 · S/N 21062939N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184N616RMMnemonics Inc · Melbourne, FLBuilt 1973 · S/N 414-0375N6170NGarmin210 LLC · Willard, MOBuilt 1978 · S/N 21062941N6173RBeyer Livestock Auction LLC · Clovis, NMBuilt 1965 · S/N T210-0073N6174BN6174b LLC · Nokomis, FLBuilt 1978 · S/N 21062698N6176RJulius Kaleb · Mesa, COBuilt 1965 · S/N T210-0076N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316N6178WBlu Sky Key West LLC · Key West, FLBuilt 1981 · S/N P21000724
Back to AD 75-09-13