AD 95-09-13

Registered aircraft · 1,061

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:95-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:95-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.

N540CASpradlin Flying Service Inc · Petersburg, TXBuilt 1976 · S/N 421C-0144N540CCAndriopulos Salguero Inc · Hialeah, FLS/N 421C0675N540NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C0809N5417CExecutive Aircraft Management Services LLC · Pompano Beach, FLS/N 421C0012N5421FAlvey Chad R · Bargersville, INBuilt 1979 · S/N 421C0660N543PMPhillips Brant · Franktown, COS/N 421C0280N5461VGoldt Robert · Simpsonville, SCS/N T30300300N5478GOn Wings Of Eagles LLC · Valley Center, CABuilt 1976 · S/N 421C0225N548GAHyannis Air Service Inc · Hyannis, MABuilt 1982 · S/N 402C0653N5497GRichardson Farms Land Mgt Inc · Pittsfield, ILS/N 421C0244N54CRCage Presnall C · Falfurrias, TXS/N 421C0812N54JQRegistered aircraftN-number assigned (import), not yet registeredS/N 414A0086N54SADodson International Parts Inc · Rantoul, KSS/N 404-0426N54TTRedcell Air Inc · Miami, FLBuilt 1981 · S/N 421C1054N54ZPSouth Aero Inc · Albuquerque, NMBuilt 1980 · S/N 404-0694N5515CIsland Fliers LLC · Sheridan, WYBuilt 1982 · S/N T30300142N5529VCandlestick Aviation Services LLC · Lewes, DEBuilt 1984 · S/N T30300303N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N554CCAmg/Sherfick Aviation LLC · Noblesville, INBuilt 1982 · S/N 421C1228N5554GGaluk Douglas P · Wisconsin Rapids, WIBuilt 1977 · S/N 421C0249N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822N555KKGe Flyer 1 LLC · Sheridan, WYS/N 421C1022N555WPSherry-Aire LLC · Sidney, MTS/N 414A0074N558BFMatrix Aviation LLC · Birmingham, MIS/N 421C0845N55LPAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0401N55RLSound Harbor Aviation LLC · Wilmington, NCS/N 421C1071N55WSFour To One LLC · Decatur, ALBuilt 1976 · S/N 421C0073N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136N567WAJasper Aviation Inc · Jasper, ALS/N 421C-0713N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425N569PAHerron Aviation Group LLC · Dexter, MIS/N 414A0461N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847N56RXKing Cobra Investments LLC · Rancho Cordova, CABuilt 1976 · S/N 421C0207N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804N575JBForbes Consolidated Inc · New Smyrna Beach, FLS/N 414A0426N575RCRichland Aviation Inc · Sidney, MTBuilt 1979 · S/N 4040431N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268N577KGMccloy Mark T · Tatum, NMS/N 421C0906N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300N57WAE2 Hangar LLC · Folsom, CAS/N 421C0451N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050N588TBVlot Cole T · Wellington, NVBuilt 1976 · S/N 421C0064N589STCurtis & Son Vacuum Service Inc · Liberty, TXS/N 421C0644N58AWAmplatz Left Aviation LLC · Rapid City, SDS/N 414A0276N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314
Back to AD 95-09-13