AD 97-07-03

Registered aircraft · 605

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:97-07-03')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-07-03')
  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.

N28DFGlobal Avionics LLC · Downey, CAS/N 31-7812121N28DVHood Geoffrey A · Gladstone, MOS/N 31-7912063N28KEGrant Aviation Inc · Anchorage, AKS/N 31-8152049N296CHTgl Partners LLC · Plant City, FLBuilt 1978 · S/N 31-7812062N297JGInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 317952043N2PNFugro USA Land Inc · Rapid City, SDBuilt 1977 · S/N 31-7752141N2XRInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 318152014N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006N30SAMsm30sa LLC · Jericho, NYS/N 31-7952142N30SCRegistration Pending · Wauchula, FLRegistration pendingBuilt 1981 · S/N 31-8152098N30TPLe Ciel Bleu LLC · Hudson, WIBuilt 1981 · S/N 31-8152062N312AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1973 · S/N 31-7305015N312CDMcwhorter Properties Graysville LLC · Anniston, ALBuilt 1980 · S/N 31-8052182N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025N315AKAlsworth Glen R Sr · Port Alsworth, AKBuilt 1978 · S/N 317852083N316AKKuspuk School District · Aniak, AKS/N 318152118N316HABidzy To Hot Aana Corp · Dillingham, AKS/N 31-7652133N317AKSafeco Leasing LLC · Port Alsworth, AKS/N 31-7752145N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043N317SFLasher Patrick R · Magnolia, DES/N 31-7300912N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144N31CRStory Aranzazu · Draper, UTS/N 31-8152011N31NWAlpha Whiskey 2 LLC · Brandon, MSBuilt 1981 · S/N 318152139N31PNRhs Consulting Ltd LLC · Reno, NVBuilt 1976 · S/N 31P-7630009N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059N31TEMiller David A · Albany, ORBuilt 1984 · S/N 31-8452012N321SJTmg Aircraft Holdings LLC · New Port Richey, FLBuilt 1977 · S/N 31-7752038N323APEm Concordia Inc · Brooklyn, NYS/N 31-8252031N323DDHd Security Systems LLC · Watertown, TNBuilt 1981 · S/N 31-8152170N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005N325FJSale Reported · Hopkinsville, KYSale reportedBuilt 1977 · S/N 31-7812007N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002N325SGTraveling Lill LLC · Key Largo, FLBuilt 1978 · S/N 317812115N32PBLease One LLC · Lafayette, INBuilt 1981 · S/N 31-8212006N32SBCook Robert W · Belair, MDBuilt 1976 · S/N 31-7612098N333EJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 31-7652055N333HFValiair Lc Trustee · Casper, WYS/N 31-8152097N333PRGriffin Wings LLC · Lithia, FLBuilt 1973 · S/N 31-7305112N334RPRegistration Pending · Seneca, SCRegistration pendingBuilt 1980 · S/N 31-8052071N33TLPaloma Uno LLC · Stuart, FLBuilt 1975 · S/N 31-7512043N33URAthena Aviation LLC · Golden, MSBuilt 1980 · S/N 318052097N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243N348GGFlplanes 21 Of Miami LLC · Miami, FLBuilt 1980 · S/N 31-8052054N34MIII Enterprises LLC · Britton, SDBuilt 1975 · S/N 31P-7630007
Back to AD 97-07-03