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.

N7MPMass Aviation Corp · Libertyville, ILBuilt 2023 · S/N 9448N7NKHall Gregory Lyman · College Station, TXBuilt 1993 · S/N E-2786N7NRHodgkins Charlie Lee III · Strawn, TXBuilt 2005 · S/N 41103N7PD426th Aero Squadron LLC · Cropwell, ALBuilt 2000 · S/N TH-1972N7PHParadox Aviation Management LLC · Port Angeles, WABuilt 2022 · S/N 8978N7QEAir Traders LLC · Fayetteville, ARS/N 0764N7RJCirrus Sr22t 2288 Inc · Wilmington, DEBuilt 2024 · S/N 10142N7RSA Lux Air LLC · Saint Louis, MOBuilt 2024 · S/N 9780N7RZZantop Reese C Trustee · Naples, FLBuilt 1990 · S/N E-2562N7SFByrd Cody · Dalhart, TXBuilt 2010 · S/N LAIV098N7SZZulu Aviation LLC · Woodbury, MNBuilt 2014 · S/N L-IV 259N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593N7VGBerland Craig A · Chandler, AZBuilt 2009 · S/N LIV-568N7WRSouthern Carbide Technologies Inc · Tuscaloosa, ALBuilt 2023 · S/N 9159N7YSMentor Aviation LLC · Las Vegas, NVFirst renewal noticeBuilt 1957 · S/N BG-389N7YVTgp Aviation Services LLC · Peyton, COBuilt 2002 · S/N 0326N7ZDEdgerton Emmett Cecil III · Dunn, NCBuilt 2005 · S/N 42068N80000Mccue Mark K · Gualala, CABuilt 1992 · S/N E-2741N8003RBig Sky Bonanza Inc · Wilmington, DEBuilt 1990 · S/N E-2558N8008KKraus Lee G Jr · Port Orange, FLBuilt 1990 · S/N E-2559N800BAN8vv Inc · Corpus Christi, TXBuilt 1981 · S/N 414A0667N800CFSparky'S Air LLC · Wilmington, DEBuilt 1990 · S/N TH-1599N800DD2826 LLC · Inola, OKBuilt 1995 · S/N 29-0024N800FUKing Air 3 Au LLC · Ozark, MOBuilt 1978 · S/N 21062792N800JCThomas Bonner Enterprises LLC · Lubbock, TXBuilt 1979 · S/N TK-90N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063N800LC54 Aero LLC · Spade, TXBuilt 1968 · S/N 18258879N800MPDb Communications LLC · Scottsdale, AZBuilt 2024 · S/N 9987N800STVenture Motorsports LLC · Helena, MTBuilt 2024 · S/N 10335N800VJAtlas Aviation LLC · Texarkana, ARBuilt 2009 · S/N 3560N800VPCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 9762N800WRams Air LLC · Waldorf, MDBuilt 2018 · S/N 1700N800ZRAir Boozer LLC · Whitehouse, TXBuilt 2023 · S/N 9474N801AGPanther Tamer Aviation LLC · Las Vegas, NVBuilt 2025 · S/N 10632N801BLN801bl LLC · Saratoga Springs, UTBuilt 2024 · S/N 10339N801DCMalibu Queen LLC · Portola Valley, CABuilt 1987 · S/N 46-08053N801GWAdashek & Baker LLC · Las Vegas, NVBuilt 2020 · S/N 2122N801JCTyzack Aviation LLC · Incline Village, NVBuilt 2018 · S/N 1833N801TEInternational Air Services Inc Trustee · Carson City, NVBuilt 2024 · S/N 10380N8021WNothing Wasted Consulting LLC · Kannapolis, NCBuilt 1992 · S/N E-2700N8026TRdz Aircraft LLC · Effingham, ILBuilt 1992 · S/N E-2701N802BTCasavia Corp · Guelph OntarioBuilt 1998 · S/N LIV-080N802CDTs Flight LLC · Saint Louis Park, MNBuilt 2001 · S/N 0103N802CSAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2006 · S/N 1935N802ESGulbrandsen Inc · Orangeburg, SCFirst renewal noticeBuilt 2017 · S/N 1482N802FPFunctional Pathways Preferred Of Tennessee LLC · Knoxville, TNBuilt 2006 · S/N 1930N802MCRunaway Plane LLC · Oklahoma City, OKBuilt 1980 · S/N 335-0044N802MSMarotta Scientific Controls Inc · Montville, NJBuilt 1983 · S/N 21064780N802NHWiechmann August J · Hubbard, IABuilt 1992 · S/N E-2694N802NXLacey David G · Locust Grove, GABuilt 2004 · S/N 1222
Back to AD 2012-10-13