OpenAirDocs.org
AD 93-24-02 R1

Registered aircraft · 806

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

N285MEN285me Holding LLC · Palm City, FLS/N 31-7405410N28BGKapowsin Air Sports Ltd · Shelton, WABuilt 1976 · S/N 31T-7720005N28DFGlobal Avionics LLC · Downey, CAS/N 31-7812121N28DVHood Geoffrey A · Gladstone, MOS/N 31-7912063N28KEGrant Aviation Inc · Anchorage, AKS/N 31-8152049N294ZPCumulus Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N 31T-8020063N296CHTgl 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 318152014N300SRLevenson Louis · Atlanta, GABuilt 1981 · S/N 31T-8104022N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294N300WPPcp Aviation LLC · Miramar Beach, FLBuilt 1978 · S/N 31T-7904006N302TAMidwest Flying Service LLC · Wilmington, DEBuilt 1980 · S/N 31T-8020046N303TSCheyenne Air LLC · Ocean City, NJBuilt 1981 · S/N 31T-8166007N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016N30DRRuble Force One LLC · Wilkinson, INBuilt 1978 · S/N 31-7912006N30DUHtf Aviation LLC · Kalispell, MTS/N 31T-7720054N30SAMsm30sa 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-8452012N321FUTms Turboprop 2xl LLC · Wilmington, DES/N 31T-8166063N321LBSpeer Transport LLC · El Cajon, CABuilt 1981 · S/N 31T-8166012N321SJTmg 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-8152170N324ARParrish Blake · Seminole, TXS/N 31T-7620052N325AKInternational 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 317812115
Back to AD 93-24-02 R1