AD 2012-10-13

Registered aircraft · 13,306

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-10-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:2012-10-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.

N8072DLong Jill A · Apo, AES/N E-2728N8073WKilo Mike LLC · Nancy, KYBuilt 1992 · S/N E-2730N8077MKriessler Scott C · Port Clinton, OHBuilt 1990 · S/N E-2565N8077XTudor George J · Mecca, CABuilt 1990 · S/N E-2534N8079ZParker Larry E Jr · Lumber Bridge, NCBuilt 1992 · S/N EA-538N807BDLx-7 LLC · Sisters, ORBuilt 2011 · S/N 0194N807BHG-Four Aviation LLC · Naples, FLBuilt 2016 · S/N 1238N807DJGreat West Produce Co Inc · Commerce, CABuilt 2001 · S/N E-3371N807GKSalimi Management LLC · Pinole, CABuilt 2012 · S/N 0368N807NHJohnson Gregory D · Elkhart, IAS/N E-2704N807RBAscensio LLC · Tyler, TXBuilt 2001 · S/N 40009N807SJTurner Strategic Technologies LLC · Norfolk, VABuilt 2025 · S/N 10698N807SRFrasca Thomas W · Englewood, FLBuilt 2006 · S/N 2067N807WSInter Island Freight LLC · Deerfield Beach, FLBuilt 1968 · S/N 4010300N8080CMelo Clayton · Westport, CTS/N 0646N8080NStratz Gregory A · Port Orange, FLBuilt 1992 · S/N CE-1688N8080PPiper Llp · Decatur, ALBuilt 1992 · S/N E-2736N8081RCook Marvin R · Portales, NMBuilt 1969 · S/N D-8994N8083FTindall Haul And Erect Corp · Spartanburg, SCBuilt 1993 · S/N E-2771N8085QWes Hughes Corp · Waldron, KSBuilt 1974 · S/N 414-0506N8087RCavanaugh Robert K · Valparaiso, INBuilt 1992 · S/N E-2738N8088JPhillips Robert Carroll III · Waxhaw, NCBuilt 1990 · S/N E-2502N808CDC M Alvarez Inc · Baton Rouge, LABuilt 2001 · S/N 0114N808DETabs Rental LLC · St Simons Island, GABuilt 2021 · S/N 2267N808DXMkair Holdings LLC · Fort Lauderdale, FLBuilt 2024 · S/N 10346N808GLWilliams Tommy J · Southlake, TXBuilt 2007 · S/N 2649N808GWWahrman Wayne · Calabasas, CABuilt 2005 · S/N 1374N808HHPacific Pump & Power (Ppp) Corp · Kapolei, HIBuilt 2013 · S/N 0538N808HWManu Aircraft LLC · Kihei, HIBuilt 2007 · S/N 2877N808KDDuggan Holdings LLC · North Kingstown, RIBuilt 2021 · S/N 2382N808LCHulsey Michael · Prescott, AZBuilt 1980 · S/N TJ-319N808MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2355N808NHAkers Gary L · Eden, NCS/N E-2817N808RGLampasso Paul · Palm Harbor, FLFirst renewal noticeBuilt 2006 · S/N L2K-269N808RWBrookway Aviation LLC · Brookhaven, MSBuilt 2019 · S/N 1987N808TWVa Office Of Emergency Service LLC · Hampton, VABuilt 1977 · S/N 340A0304N808WMCarney Adam S · Middletown, NJBuilt 1995 · S/N 29-0072N808WRAlta Aviation LLC · Baileys Harbor, WIBuilt 2004 · S/N E-3570N808WWMge III LLC · Beverly Hills, CABuilt 2023 · S/N 9269N8091QKhag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 402B0369N8095FBrown Dr Jay · Ames, IABuilt 1992 · S/N E-2695N8095UKaswan Michael G · Oklahoma City, OKBuilt 1992 · S/N CE-1692N8099HHerber Aircraft Service Inc · El Segundo, CABuilt 1992 · S/N E-2743N809ASHaack Gregory · Signal Hill, CABuilt 2008 · S/N 3191N809CRPb&J Aviation LLC · Canonsburg, PABuilt 2020 · S/N 2235N809DSCook Michael R · Forest, VABuilt 2004 · S/N 0998N809HSPlg LLC · Westminster, COBuilt 2022 · S/N 8691N809LTLae Aviation LLC · Ragley, LABuilt 2015 · S/N 4176N809MP809mp LLC · Manchester, NYBuilt 2015 · S/N 1221N809MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 8915
Back to AD 2012-10-13