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.

N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203N3968GWatkins Aviation LLC · Golden Valley, MNBuilt 1977 · S/N 421C0422N39WHGolden Touch LLC · Kalispell, MTBuilt 1976 · S/N 421C0070N3DJHatch Hyrum G · Chandler, AZS/N 421C0011N400ATAlpha Tango Aviation Inc · Middletown, DEBuilt 1981 · S/N 402C0510N400BSMb Aviation Inc · Larue, TXS/N 421C1089N400FCCrosswind Enterprises LLC · Box Elder, SDS/N 414A0023N401SXHyannis Air Service Inc · Hyannis, MAS/N 402C0447N401TJHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0109N402BKN402bk LLC · Nantucket, MABuilt 1978 · S/N 402C0689N402HGHyannis Air Service Inc DBA · Hyannis, MABuilt 1985 · S/N 402C1016N402JHAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0500N402RSTropical Transport Services Ltd · San Jaun, PRBuilt 1980 · S/N 402C0402N402SAAlly Mohamed Yacoob · Fort Lauderdale, FLS/N 402C0623N402SBGlemone Airways Inc · Wilmington, DEBuilt 1979 · S/N 402C0082N402VNHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0488N402VPVespa Power Products LLC · Visalia, CAFirst renewal noticeS/N 402C0025N402ZKAirplane One LLC · Miami Springs, FLBuilt 1981 · S/N 402C0028N404CPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 404-0238N404CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1977 · S/N 404-0065N404DGSubgup LLC · Naples, FLS/N 414A0111N404ECSarah Express Airways LLC · Miramar, FLS/N 404-0646N404JRBowlin & Associates Inc · Clayton, GAS/N 421C0317N404NEFehlhaber Wolfgang M · Port Orange, FLBuilt 1981 · S/N 404-0857N404NSJ + D Aviation Services LLC · Centerville, MABuilt 1980 · S/N 402C0421N404PJPrivate Jet LLC · Miami Springs, FLBuilt 1981 · S/N 402C0513N4057CAberdeen Flying Service · Aberdeen, SDBuilt 1982 · S/N 414A0848N406BKN406bk LLC · Nantucket, MABuilt 1984 · S/N 402C0807N406GAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0329N406RCIsland Flights Inc · Wilmington, DEBuilt 1981 · S/N 402C0470N409BKHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0651N40MEUnlimited Boat Sales Inc · Page, AZS/N 421C1241N40RUMoore Terry Alexander Trustee · Adel, GABuilt 1980 · S/N 421C0878N40SKSides Family Management LLC · El Paso, TXBuilt 1979 · S/N 414A0323N410AJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 421C1093N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524N411CKFairchild Bill R · Dalhart, TXS/N 421C0229N411MZSongbird Air LLC · Lakewood, COBuilt 1980 · S/N 421C1002N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675N412BPMission Hardward Ltd Co · Savannah, GABuilt 1983 · S/N T30300213N412CAAirswiss Inc · Wilmington, DES/N 402C0005N413BMLee Aviation LLC · Sheridan, ARBuilt 1977 · S/N 414A0004N413VVGardner John · New Hudson, MIBuilt 1979 · S/N 421C-0641N414AKValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 414A0321N414AMToucan Aviation LLC · Lafayette, LABuilt 1982 · S/N 414A0850N414ATCreekmore Arnold · Somerset, KYBuilt 1978 · S/N 414A0209N414AVChoate Oilfield Services LLC · Hennessey, OKS/N 414A0294N414BTrojan Enterprises LLC · Dover, DES/N 414A0109N414BBDougherty Forestry Manufacturing Ltd Co · Hinton, OKS/N 414A0839
Back to AD 95-09-13