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.

N68685S&S Airplane LLC · Knoxville, TNS/N 421C1102N6869Z421 Holdings LLC · Zanesville, OHS/N 421C1111N68752Hyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0518N6875DHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0511N6879RHyannis Air Service Inc · Hyannis, MAS/N 402C0611N6882MScuttle421 LLC · Sugar Land, TXS/N 421C1074N698DRAtm Asset Management LLC · Nashville, TNFirst renewal noticeS/N 421C0235N699TGTkg Aviation Inc · Port Orange, FLBuilt 1978 · S/N 414A0081N700FBBocre Leasing Inc · Hauppauge, NYBuilt 1977 · S/N 421C0342N700HBLucky7 Air LLC · Lenoir, NCBuilt 1982 · S/N 414A0810N700KBCalifornia Oregon Development LLC · Portland, ORBuilt 1983 · S/N T30300211N700LCRent Collector LLC · College Station, TXS/N 421C0836N7037EHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0471N706AAArcher Automotive Inc · Houston, TXBuilt 1981 · S/N 421C1075N706CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0095N706NCGaylord Hangers LLC · Gaylord, MIBuilt 1975 · S/N 421C0037N7079FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 404-0681N707HATailwinds Aero LLC · Dubuque, IAS/N 421C1044N707RLApplegate Properties LLC · Morris, ILS/N T303-00008N707TPRicker David · Conway, ARS/N 421C0271N711KZPlp Casino Game Development LLC · Leesburg, FLBuilt 1976 · S/N 421C0023N712JDCpch Aviation LLC · Jacksonville, FLS/N 421C0908N7135GRegistered aircraftBuilt 1977 · S/N 421C0284N717BDWeathered Aviation Inc · Rogers, ARBuilt 1979 · S/N 414A0337N717LRJnnss LLC · Hillsborough, NJS/N 421C1109N71JRSouthgate Development Inc · Wichita Falls, TXBuilt 1976 · S/N 421C0066N720FSVero Executive Flyers Inc · Fort Pierce, FLS/N 421C1250N721HBBrazilco Aviation LLC · Missouri City, TXS/N 421C0629N723ESEs Owens LLC · Mustang, OKBuilt 1982 · S/N 421C1217N726RTCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 421C0087N727ESHoover421 LLC · Rockport, TXBuilt 1977 · S/N 421C0268N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513N73HMTrn Aviation LLC · Lewes, DES/N 421C0234N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043N747CAAction Air Express Inc · Santa Monica, CAS/N 421C0850N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905N749CABig Bear Resorts Inc · Big Bear Lake, CAS/N 421C1239N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217N754KCPlane Crazy Aviation LLC · Fargo, NDBuilt 1981 · S/N 414A0803N755BCMav Management LLC · Rockledge, FLBuilt 1978 · S/N 421C0497N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049N75TTReisback Scott · Olalla, WAS/N 414A0405N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214
Back to AD 95-09-13