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.

N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418N33MHAkeyson Edward W · Durham, CTBuilt 1982 · S/N T30300076N33UWPadf LLC · Fort Collins, COS/N 421C0676N33WVInarayan Inc · Winter Park, FLS/N 414A0082N341RBRomeo Bravo LLC · Thompson, MOS/N 421C1112N342RCHyland'S Pharmacy LLC · Wheeler, TXBuilt 1982 · S/N 421C-1243N344TCInternational Air Services Inc Trustee · Carson City, NVS/N 421C0424N346CHAce Flight Center Inc · St Thomas, VIBuilt 1979 · S/N 402C0029N3479VInternational Air Services Inc Trustee · Carson City, NVS/N T30300273N347ABTropical Transport Services Ltd Inc · San Juan, PRBuilt 1980 · S/N 402C0347N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34AGJ D Aviation Leasing LLC · Mundelein, ILS/N 421C0901N350GMCannonball Trucking Inc · Houston, TXBuilt 1978 · S/N 414A-0120N351ABTropical Transport Services Ltd · San Juan, PRBuilt 1980 · S/N 402C0351N351HCBig Elk Aviation LLC · Elk City, OKS/N 414A0801N365FDci Air LLC · Dodge City, KSBuilt 1980 · S/N 421C0854N366MN366m LLC · Dover, DES/N 414A0026N366MCHastings Steve T · Corpus Christi, TXS/N 414A1005N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494N369RKKrum Force 1 LLC · Wichita, KSBuilt 1976 · S/N 421C0072N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071N37127Richland Aviation Inc · Sidney, MTBuilt 1977 · S/N 404-0114N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N371SBN333bc LLC · Franktown, COS/N 421C1072N37404Bear Giant LLC · Eden Prairie, MNBuilt 1977 · S/N 421C0339N37417Registered aircraftS/N 421C0344N37424Flight Development LLC · Wichita, KSS/N 421C0658N37475N37475 Management LLC · Las Vegas, NVBuilt 1977 · S/N 421C0412N37478Ghareeb Enterprises Inc · Charleston, WVS/N 421C0415N37543Construction Solutions & Consulting LLC · Sedalia, MOS/N 414A0002N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468N377JMSanchez Joshua A · Bosque, NMBuilt 1976 · S/N 421C0221N378KAga Aviation LLC · Lewes, DES/N 421C0499N379TWTanglewood Aviation LLC · Fort Mill, SCBuilt 1981 · S/N 414A-0616N37FSLuxury Transportation LLC · Talladega, ALS/N 414A0830N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823N37UJet Set Aircraft Inc · Van Nuys, CABuilt 1977 · S/N 414A0010N382BWWd Aviation Group Inc · Atlanta, GAS/N 421C0711N382CRSkyport Aviation LLC · Oxford, MIBuilt 1982 · S/N T30300096N385CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0111N38CJAirplane Seven LLC · Watkins, COBuilt 1978 · S/N 402C0023N38GJMonahan Jeffrey L Trustee · Long Beach, CABuilt 1982 · S/N 414A0829N3908CMccreery Aviation Co Inc · Mcallen, TXBuilt 1976 · S/N 421C0136N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3922CN3922c LLC · Dover, DEBuilt 1977 · S/N 421C0419N3923CSwope Aviation LLC · Elizabethtown, KYBuilt 1976 · S/N 421C0147
Back to AD 95-09-13