OpenAirDocs.org
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.

N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711N1678Dgs Aviation LLC · Georgetown, DEBuilt 2026 · S/N 11447N1678TGabaldon Martin · El Paso, TXS/N 414-0471N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713N1679XBouchereau Raymond Jr · San Dimas, CABuilt 1975 · S/N 21060714N167AJRogers Wallace III · San Antonio, TXBuilt 2017 · S/N 1515N167AWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 340A0537N167CAGoody For US Aviation LLC · Miami, FLBuilt 2026 · S/N 11191N167CTBlomgren Paul · Yorba Linda, CABuilt 2008 · S/N 2959N167JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 9410N167KMRegistered aircraftBuilt 2025 · S/N 10462N167SPEnnis James D Jr Trustee · Dalton, NHBuilt 2009 · S/N 3580N167TRBarton Aviation LLC · San Antonio, TXBuilt 1998 · S/N TH-1849N167WAGrid Aero Inc · San Leandro, CABuilt 1976 · S/N 402B1044N1681TDrc Air LLC · Wilmington, DEBuilt 2014 · S/N 4081N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725N1687XMorton Douglas E · Cody, WYBuilt 1975 · S/N 21060722N168AGN168 LLC · Irvine, CABuilt 2024 · S/N 10211N168CCLanham Aviation LLC · Simpsonville, KYBuilt 1990 · S/N TH-1606N168GGWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 414A0304N168JGFlymore LLC · New City, NYBuilt 1999 · S/N E-3253N168LLSteve Jackson Racing LLC · Helena, MTBuilt 2014 · S/N L2K-168N168MPValiair Ltd Co Trustee · Casper, WYBuilt 2007 · S/N 2692N168PSBkt LLC · Leawood, KSBuilt 2023 · S/N 9173N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460N168WACharles Michel · St Thomas, VIBuilt 1984 · S/N 402C0808N169DWA&P Properties LLC · Manns Choice, PABuilt 2005 · S/N 1523N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N169HWood Wendell · Holland, TXBuilt 2001 · S/N 29-0264N169HTAerie Leisure Inc · Phoenix, AZBuilt 2005 · S/N 41054N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169N169KSSvetfur Aviation LLC · Camden, SCBuilt 1978 · S/N 414A0015N169MRSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2016 · S/N 1331N169PJBernard Douglas A · New Iberia, LABuilt 2005 · S/N 41065N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101N16BQBeard Bradley A · Hanford, CABuilt 2004 · S/N LIV492N16DXWerner Eric J · Arlington, WABuilt 2007 · S/N L2K-285N16EUCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11380N16EZAmerican Aerial Survey Inc · Rancho Murieta, CABuilt 1978 · S/N 310R1277N16GBWester Lawrence Cale · Star, IDBuilt 1973 · S/N U20602075N16LTClausen Frederik M · Lake Forest, ILBuilt 1988 · S/N 4608130N16MTAmarone LLC · Charleston, SCBuilt 2020 · S/N 2058N16MYAgi Inc · La Canada Flt, CABuilt 2025 · S/N 10476N16NHRutgers Nicholas G IV · Camas, WABuilt 1985 · S/N E-2220N16PMcmurray Justin John · Durham, NCBuilt 1999 · S/N TH-1925N16RMBbj Aviation LLC · Shelby Township, MIBuilt 1997 · S/N 29-0112N16SWWilliams Robert S · Redmond, ORBuilt 1998 · S/N 066N16VABs LLC · North Vernon, INBuilt 2003 · S/N 42008N16WDFront Run Investors LLC · Commerce, GABuilt 2017 · S/N 4552N16YZBerit Merkab LLC · Monroe, NCBuilt 2020 · S/N 2075
Back to AD 2012-10-13