AD 2012-09-10

Registered aircraft · 3,894

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

N11TKBelfort Aviation LLC · Park City, UTBuilt 2010 · S/N EVO-006N11WNRds Aviation LLC · Elkhart, INBuilt 1982 · S/N LA177N12Federal Aviation Administration · Oklahoma City, OKBuilt 2009 · S/N LJ-1966N120NCDavis Aviation Inc DBA · Brandon, MSBuilt 1982 · S/N BB1056N120QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1995 · S/N 120N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9N120WWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 4697047N1213SWright Caravan LLC · Seattle, WABuilt 1995 · S/N 20800243N12155International Air Services Inc Trustee · Carson City, NVBuilt 1996 · S/N 208B0562N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336N121DKAutomotive Air II LLC · Belcamp, MDBuilt 2007 · S/N BB-1995N121HARedding Aero Enterprises Inc · Redding, CABuilt 1988 · S/N 208B0069N121JPChoice Farms LLC · Wilmington, DEBuilt 1998 · S/N LJ-1520N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049N121MACisnero Francisco Javier Picazo · Mckinney, TXBuilt 2009 · S/N 4697406N121NSPorto Mark · Wilmington, DEBuilt 2007 · S/N 4697292N121TDRegistration Pending · Montgomery, ALRegistration pendingBuilt 1979 · S/N 78-23138N121TRRay Timothy E · Fort Walton Beach, FLBuilt 2019 · S/N 4697669N1222BKelly Douglas E · Bethesda, MDBuilt 1980 · S/N 425-0060N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496N1229CKalinin Partners LLC · Juneau, AKBuilt 1996 · S/N 208B0589N1229XTalkeetna Aero Services Inc · Anchorage, AKBuilt 1992 · S/N 20800212N1229ZKalinin Partners LLC · Juneau, AKBuilt 2002 · S/N 208B0943N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651N122JBWestwind Aircraft Leasing LLC · Phoenix, AZBuilt 2003 · S/N 208B1025N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32N122UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-122N1232YPa1 208b-0566 LLC · Fort Lauderdale, FLBuilt 1996 · S/N 208B0566N123FWBhmp King Air LLC · Fort Worth, TXBuilt 2001 · S/N LJ-1655N123FXFreefall Express · Gardiner, NYBuilt 1969 · S/N 200N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587N123TSRyen Air LLC · Wilmington, DEBuilt 2005 · S/N 4697219N123ZCJasper Industries Ltd · Mokena, ILBuilt 2002 · S/N 229N1242YSkydive Baltimore LLC · Lincoln, DEBuilt 2002 · S/N 208B0939N124CTop Tier Truck And Trailer LLC · Amarillo, TXS/N EVO-029N124EBPremium Air LLC · Hibbing, MNBuilt 1995 · S/N FL-126N124GADriscoll Health Care Services · Corpus Christi, TXBuilt 1982 · S/N BB-1039N124KTGams Air LLC · Doral, FLBuilt 1976 · S/N BB-124N124RFRandigo LLC · Wilmington, DEBuilt 1988 · S/N 20800018N124WRH.A.I. Services Inc · Justin, TXBuilt 1980 · S/N BB-664N1256PPlanemasters Ltd · West Chicago, ILBuilt 1996 · S/N 208B0564N1258BSouthern Airways Pacific LLC · Addison, TXBuilt 2007 · S/N 208B1258N125KSAlpine Aviation Inc · Provo, UTBuilt 1985 · S/N BL-125N125RFRandigo LLC · Wilmington, DEBuilt 2012 · S/N 208B2330N125TECj Brown Express LLC · Graettinger, IABuilt 1992 · S/N BB-1422N125TSDouble J Aviation Inc · Klamath Falls, ORBuilt 2007 · S/N BB-1993N1262TColdsteel Holdings LLC · Naples, FLBuilt 1987 · S/N 4250236N12666Wdr Inc · Grand Forks, NDBuilt 1996 · S/N 20800250
Back to AD 2012-09-10