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.

N36KPAir Lease Inc · Bridgeport, WVBuilt 1989 · S/N EA-495N36LLBeech Bums Aviation II LLC · Linden, MIBuilt 1980 · S/N EA-155N36LMN36lm LLC · Spicewood, TXS/N EA-67N36MNKad Enterprises LLC · Everett, WABuilt 1980 · S/N EA-79N36NCrossman Kyle D · Monroe, MIBuilt 1980 · S/N 3350004N36NMFrost Cavin Bert · Odessa, TXS/N EA-316N36PKGoodman Ronald · Dos Palos, CABuilt 2000 · S/N EA-654N36PVLong Wing Aviation LLC · Houston, TXBuilt 2002 · S/N EA-695N36RWBas Part Sales LLC · Greeley, COBuilt 1981 · S/N P21000691N36TEGary Vaughan Construction Inc · Leland, MSBuilt 1983 · S/N EA-389N36TKKinsey & Co Inc · Las Vegas, NVBuilt 1985 · S/N EA-444N36TMPendragon LLC · Stuart, FLBuilt 1979 · S/N EA-7N36TRClark Tj · Saint George, UTS/N EA-159N36XArchangel Aviation LLC · Cleburne, TXBuilt 1976 · S/N 21061650N36YBGrey Fox Corp · La Canada Flt, CAS/N EA-331N36YMRankay Air LLC · Sanger, CABuilt 1983 · S/N EA-369N3701NGreat Lakes Aero Marine LLC · Green Bay, WIBuilt 1980 · S/N EA-141N3704GGap Holdings LLC · Dover, DEBuilt 1980 · S/N EA-145N3708KWard Ron · Oklahoma City, OKBuilt 1980 · S/N EA-153N37126Robison Charles T · Pierre, SDBuilt 1980 · S/N EA-156N3714ZQuick Foam Insulation LLC · Lubbock, TXBuilt 1980 · S/N EA-160N37181Jrs Aviation LLC · Falls City, NEBuilt 1980 · S/N 414A0511N3720QM M & O Aviation Inc · Northglenn, COBuilt 1966 · S/N D-8373N37236Nay Richard B · Gunnison, UTBuilt 1981 · S/N EA202N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N37285Java Air LLC · Visalia, CABuilt 1979 · S/N 340A0953N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215N372JCompass Rose Services Inc · Powell Butte, ORBuilt 1966 · S/N 320D0114N37302Elrod Jason A · Seattle, WABuilt 1977 · S/N 340A0334N37306Frescomar USA LLC · Miami, FLS/N 340A0336N37315Atlantic Coast Contractors Inc · Denver, NCBuilt 1977 · S/N 340A0341N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906N37343Bearings & Belts LLC · Carlsbad, NMBuilt 1977 · S/N 340A0358N37356Congregation Rosh Hagivah Inc · Waterbury, CTBuilt 1977 · S/N 340A0364N37360Tkn Holdings LLC · Pima, AZBuilt 1978 · S/N 340A0402N3737Qualitair LLC · MichelstadtBuilt 1985 · S/N 468508060N37376Huntley Storage Units LLC · Billings, MTBuilt 1977 · S/N 340A0374N373ARPaul Brightwell Dirtworks Inc · Springer, OKBuilt 1979 · S/N P21000308N373DHigh Flight Baron LLC · Holland, MIBuilt 1980 · S/N TJ-299N373PJRock Creek Corp · Henderson, NVBuilt 1978 · S/N 21062887N373STLassen Peter C · Ventura, CAS/N EA-308N37402Viking Construction Inc · Hayden Lake, IDBuilt 1980 · S/N EA-165N3745PRiviera Aircraft Inc · Lewes, DEBuilt 1978 · S/N P21000052N3747CS I Air Inc · Dover, DEBuilt 1975 · S/N 414-0818N3752CMiller Robert G · Clear Lake, IAS/N 414-0819N3753QMintz Jason · Houston, TXBuilt 1967 · S/N D-8393N3758CDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 414-0839N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226N375RHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0468
Back to AD 75-09-13