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.

N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213N763EAHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0497N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211N764EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0237N764PBBisono Pablo R · Guaynabo, PRS/N 402C0338N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401N769EAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0303N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204N771EAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0046N775RCAirswiss Inc · Wilmington, DEBuilt 1980 · S/N 402C0311N787DRBad Aire LLC · Aledo, TXS/N 414A0503N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045N78NGRam Aero Development Inc · Waco, TXS/N 414A0617N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263N79DCBnb Marine LLC · Miami, FLS/N 414A0212N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278N79JFFour Twenty One LLC · Kalispell, MTBuilt 1977 · S/N 421C0340N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667N802HLAir Hammer LLC · Wilmington, DES/N 414A0820N805PRValiair Lc Trustee · Casper, WYBuilt 1985 · S/N 414A1206N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004N809RQSouth Aero Inc · Albuquerque, NMBuilt 1981 · S/N 404-0809N80BSSonrise Aviation LLC · Portland, INBuilt 1977 · S/N 404-0048N80JJZing Aviation And Marine LLC · New Smyrna, FLFirst renewal noticeS/N 414A0412N80LGTru North Aviation LLC · Ironwood, MIBuilt 1975 · S/N 421C0021N810BWHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0279N811NATm Aero LLC · Riverview, FLS/N 421C-1082N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413N812SRVantage Point Northwest Aviation LLC · Sheridan, WYBuilt 1979 · S/N 414A0326N817LLJg Aero LLC · Clermont, FLS/N 421C0230N8181GAirplane LLC · Coeur D Alene, IDS/N 421C0302N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085N818ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0501N818DHCouch Fred · Fort Worth, TXS/N 421C0840N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873N818XJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 421C1021N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291N821KAKa Consulting LLC · San Juan, PRBuilt 1981 · S/N 421C1203N821TTHome By Dark LLC · Fredericksburg, TXBuilt 1976 · S/N 421C0041N822BKPropilot LLC · San Juan, PRS/N 421C0822N824RBShark Water Systems LLC · Hobbs, NMBuilt 1979 · S/N 414A0411
Back to AD 95-09-13