OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,307

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.

N140CDCirrus Design Corp · Duluth, MNBuilt 2001 · S/N 1023N140JRobert D Grace LLC · Amarillo, TXBuilt 1981 · S/N 414A0650N140KBMcclendon Dan · Burleson, TXBuilt 1979 · S/N EA 36N140KMKnight Edge LLC · Clearwater, FLBuilt 1981 · S/N 414A-0674N140RBKessler Nicholas · Central Point, ORBuilt 1979 · S/N 310R1807N140TPHickox Joseph · Rollins, MTS/N 340A0235N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693N1411GTd Investments LLC · Oakdale, CAS/N 42556N1415KColumbia N1415k LLC · Leesburg, INBuilt 2006 · S/N 42547N1416CSpanos Dean T · Port Matilda, PABuilt 2015 · S/N 1198N1416RSkyhawk LLC · Great Falls, VABuilt 2020 · S/N 4975N1417WInternational Air Services Inc Trustee · Carson City, NVS/N 42523N141AMMckendrick Ain · Redwood City, CABuilt 2002 · S/N 40038N141ECDcomm Inc · Austin, TXBuilt 2007 · S/N 2556N141HTBazman Aviation LLC · Harbor Springs, MIBuilt 2006 · S/N 2219N141JWGray William C · Starkville, MSBuilt 2010 · S/N 0058N141KJVelox Aegis Inc Trustee · Wilmington, DEBuilt 2014 · S/N 0832N141KTAscensis LLC · Wilmington, DEBuilt 2022 · S/N 8537N1420NKlomhaus Paul · Poplar, WIBuilt 1978 · S/N 310R1398N1422MSmith Christopher J · Saint Augustine, FLBuilt 2006 · S/N ES-155N142AZLorenz Reiff A · Kettering, OHBuilt 2022 · S/N 3RX068N142BKCirrus Sr22 11508 Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11508N142CGlc Equipment Leasing LLC · Paragould, ARBuilt 2018 · S/N 4714N142CWCarbon Wing LLC · Fishers, INBuilt 2006 · S/N 1911N142DCirrus Design Corp · Knoxville, TNBuilt 2017 · S/N 4587N142DBN 10 Aviation LLC · Gallatin, TNBuilt 2019 · S/N 1894N142GXDicey Emery B · Port Orange, FLBuilt 2004 · S/N 29-0342N142LCAerocareers Nfp · Columbia, ILBuilt 1998 · S/N 40003N142PFirelands Management LLC · Sandusky, OHBuilt 2024 · S/N 10220N142RDS-Turns LLC · Indn Hbr Bch, FLBuilt 2024 · S/N 10361N142SDSch Aviation Inc Trustee · Kings LynnBuilt 1975 · S/N 414-0635N142TWInternational Air Services Inc Trustee · Carson City, NVBuilt 1998 · S/N TH-1841N142WAWhisair LLC · Little Rock, ARBuilt 2024 · S/N 9788N1439010319 LLC · Hudson, NHBuilt 2023 · S/N 9266N143ABMisch Keith · Staten Island, NYS/N 29-0400N143CGavin Lauren Aviation LLC · Miami, FLBuilt 2008 · S/N 3224N143CRNkm LLC · Glasgow, MTBuilt 1993 · S/N EA-550N143FL143fl LLC · Roseville, MIBuilt 2026 · S/N 11180N143MDEgnazia Plane LLC · Miami, FLBuilt 2025 · S/N 10440N143PMStorm Aviation LLC · Sacramento, CABuilt 2020 · S/N 2085N143RSKidwell Aviation LLC · Apopka, FLBuilt 2020 · S/N 2219N143SGPalm Tree Aloha Aviation LLC · Cameron Park, CABuilt 2026 · S/N 11514N143TMSchnautz Danny R · Pasadena, TXBuilt 2000 · S/N 29-0242N143VBBurke Farm Management Service Inc · Waynesboro, GABuilt 2017 · S/N T24002143N143WWNielsen Mark Andrew Trustee · Pagosa Springs, COBuilt 2018 · S/N 1734N1443TGrasso John A · Mount Laurel, NJBuilt 2007 · S/N 42534N1446CFour Six Chuck LLC · Maynard, MABuilt 2003 · S/N 0480N1447CAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2003 · S/N 0498N144AEMinard Stephan · Queen Creek, AZBuilt 2002 · S/N 40042N144DGSiktberg Timothy J · Nashville, TNBuilt 1999 · S/N LIV-144-P
Back to AD 2012-10-13