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.

N702GYCirrusly LLC · Las Vegas, NVBuilt 2024 · S/N 10095N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672N702VKLft Texas Aviation LLC · Austin, TXBuilt 2025 · S/N 10500N702WStier Michael E · Chandler, AZBuilt 2013 · S/N 0528N7037EHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0471N703DRMilligan Holdings LLC · Medford, ORBuilt 2015 · S/N 4166N703ELN703el LLC · Sandy, UTBuilt 2019 · S/N 2038N703LBRed Legs Aero LLC · East China, MIBuilt 2026 · S/N 11415N703RGEfficiency LLC · Helena, MTBuilt 2020 · S/N 4952N703SRRegistered aircraftBuilt 2025 · S/N 10421N703TECirrus Design Corp · Knoxville, TNBuilt 2019 · S/N 4740N703TPT & P Premier Aviation LLC · Casper, WYS/N 1340N704BAiron2 LLC · Austin, TXBuilt 2001 · S/N E-3372N704CTHype Holdings LLC · Denver, NCBuilt 2023 · S/N 9633N704DRCactus Aviation LLC · Phoenix, AZBuilt 2011 · S/N 3786N704GMLocke Stephen G · Charlotte, NCBuilt 2023 · S/N 9594N704NEArian Air LLC · Cambridge, MABuilt 2004 · S/N 1016N704RBravo Fox Squared LLC · Lincoln, NEBuilt 2006 · S/N 2147N704TEDestin Pilots LLC · Fort Walton Beach, FLBuilt 2015 · S/N 1027N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085N705CMtm Investments LLC · Goshen, INBuilt 2002 · S/N 0418N705CCPappa Mike Holdings LLC · Rayville, LABuilt 2016 · S/N 4350N705CDLearjetjohn Flying Club LLC · Moulton, ALS/N 0005N705GWFba Aviation LLC · Wildwood, FLBuilt 1991 · S/N TH-1631N705SAVisser Stephen Barney · Lakewood, COBuilt 2007 · S/N 2668N706CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0095N706JHJgharvey Solutions LLC · Roswell, GABuilt 2025 · S/N 10695N706PDPlatanus LLC · Wellington, FLBuilt 2014 · S/N 0854N706RFDeeper Shades LLC · Lafayette, LABuilt 2021 · S/N 2252N706TDRegistered aircraftBuilt 2020 · S/N 2182N707AZColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 2022 · S/N 8614N707BWDrago Air LLC · Mulberry, INBuilt 1984 · S/N 340A1812N707DKSunshine Peak LLC · Saint Louis, MOBuilt 2013 · S/N TH-2374N707EBErnst Aviation LLC · Spring House, PABuilt 2025 · S/N 10965N707GGLiberty Flight LLC · Goshen, NYBuilt 2006 · S/N 2251N707JKLiquid Dreams LLC · Wake Forest, NCBuilt 2024 · S/N 9866N707KWWaters Aero Marine Inc · South Thomaston, MEBuilt 1975 · S/N U20602619N707LAStowers Machinery Corp · Knoxville, TNBuilt 1993 · S/N TH-1685N707LHN707lh LLC · Brush, COS/N ES104N707LJFront Row LLC · Los Alamos, NMBuilt 1979 · S/N EA-4N707LWZenith Ascent LLC · Phoenix, AZBuilt 2024 · S/N 10309N707MMEaa Aviation Foundation Inc · Oshkosh, WIBuilt 2003 · S/N L2K-221N707MPEmmet Street Holdings LLC · Saint Petersburg, FLBuilt 1978 · S/N TJ-166N707PVGordon Investments LLC · Queen Creek, AZBuilt 2015 · S/N 1063N707RLApplegate Properties LLC · Morris, ILS/N T303-00008N707SWNep Air LLC · Vineland, NJBuilt 2025 · S/N 10889N707TDWhite Plains Enterprise LLC · Kalispell, MTBuilt 2005 · S/N 1363N707THFly Boys LLC · Lincoln, NEBuilt 2003 · S/N 0707N707WYBair John H · Golden, COBuilt 2015 · S/N 1096
Back to AD 2012-10-13