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.

N833JRWagwad LLC · Manlius, NYBuilt 2016 · S/N 1460N833MAberle Jonathan Andrew · Denver, NCBuilt 2005 · S/N 1338N833RCTime Machine Adventures LLC · Minot, NDBuilt 2010 · S/N 3689N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809N833SD3 Sierra Delta LLC · Orange, CABuilt 2007 · S/N 2327N833SRN833sr LLC · Mount Sterling, KYBuilt 2005 · S/N 1530N833TXN833tx LLC · Little Rock, ARBuilt 1978 · S/N TJ-153N8345QKatahdin Air Service Inc · Hermon, MEBuilt 1976 · S/N U20603206N834AKGilreath Todd L · Benton, LABuilt 2005 · S/N 1288N834CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N 0168N834HSN873wt Aviation LLC · Lewes, DEBuilt 2025 · S/N 10682N834LAHampton Jeffrey · Wayne, ILBuilt 2003 · S/N 0463N834LCOver And Out LLC · Sevierville, TNBuilt 2022 · S/N 8689N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213N8356NNielson Frederick P · Mesquite, NVS/N D-8744N835MSBeasley Michael P · Byron, GABuilt 2022 · S/N 01N835ZCoastal Cirrus LLC · Aliso Viejo, CABuilt 2011 · S/N 0126N836JBReis James C · Lake Ozark, MOBuilt 2000 · S/N E3312N836LGFly A36 LLC · Browntown, WIBuilt 2001 · S/N E-3405N836RFNuage Software Corp · Saint Petersburg, FLBuilt 2002 · S/N 40051N836ZJAltera Group LLC · Brentwood, TNBuilt 2023 · S/N 9063N837DD Flight School LLC · Altoona, PABuilt 2024 · S/N 10096N837EGZachariah Craig Powell · Salina, KSS/N E-2467N837MLBombero Aviation LLC · Childress, TXBuilt 1994 · S/N EA558N837MMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2013 · S/N 4022N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520N8388GTrombly Daniel · Franklin, NHBuilt 2003 · S/N 0470N8388TEmerald Aviation Inc · Miami, FLBuilt 2007 · S/N 2396N838CDQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 0339N838GGirus Cirrus Inc Trustee · Wilmington, DEBuilt 2009 · S/N 3524N838WPHeartland Air Leasing LLC · Coon Rapids, MNBuilt 2017 · S/N 4444N8394QPacific Union College · Angwin, CABuilt 1976 · S/N U20603255N839CRDonnellan Aviation Inc · White Plains, NYBuilt 2024 · S/N 9839N839CTFast Flyers Aviation Partners LLC · Leawood, KSBuilt 2008 · S/N 2938N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633N839SR839sr LLC · Rocky Mount, NCBuilt 2007 · S/N 2726N839WXBezner Partners LLC · Texline, TXBuilt 2004 · S/N 1154N83CCDelta Delta LLC · Fargo, NDBuilt 2019 · S/N 1872N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578N83CMSchmitt David W · Sylvania, OHBuilt 2017 · S/N 1690N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615N83FLHoopoes Holding LLC · Newton, MABuilt 2026 · S/N 11340N83GHTebow William · Bunkie, LABuilt 1978 · S/N 310R1285N83HBJennifer Air LLC · Mooresville, NCBuilt 2024 · S/N 9821N83JTLewis Thomas · Belton, TXBuilt 1976 · S/N 414-0835N83KKLowe Aviation Co · Macon, GABuilt 1996 · S/N TH-1781N83MWMarine Warehouse 3 Inc · Wilmington, NCBuilt 2023 · S/N 9351N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350N83RJMckenzie Aviation Corp · Port Orange, FLS/N 29-0185N83UMRegistered aircraftBuilt 2025 · S/N 10452
Back to AD 2012-10-13