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.

N2249SDlw Flight Services LLC · Waterloo, ILBuilt 1976 · S/N 21061193N224APowercat Aviation LLC · Yukon, OKBuilt 2018 · S/N 1810N224AJH4 Aviation LLC · Redding, CABuilt 2024 · S/N 10255N224ARAvtac Solutions LLC · Oneida, TNBuilt 2001 · S/N 0137N224AVAirplanesusa LLC · Schaumburg, ILS/N 2324N224BGSlo Cal Aviation LLC · Arroyo Grande, CABuilt 2017 · S/N 4469N224BTCacchiotti Lawrence F · Yakima, WABuilt 2002 · S/N 0370N224CESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2016 · S/N 4396N224CFTitan Land Company LLC · Medford, ORS/N 2926N224CKJett Aviation LLC · Orangeburg, SCBuilt 2013 · S/N 0603N224CTJust Go Man LLC · Scottsdale, AZBuilt 2011 · S/N 0105N224DAAiralley LLC · Kingsport, TNBuilt 2008 · S/N 2988N224DDDe Maio Dorian Albert · Las Vegas, NVBuilt 2007 · S/N 2625N224DGFahrer Scott M · Sunrise Beach, MOBuilt 2002 · S/N 0275N224DPBlue And Gold Aviation LLC · Marietta, OHBuilt 1991 · S/N E-2599N224DRN224dr LLC · Morristown, NJBuilt 2000 · S/N EA-660N224EBVasquez Aviation LLC · Lake Placid, FLBuilt 2005 · S/N 1287N224EJGlenn Air LLC · Ponte Vedra Beach, FLBuilt 2023 · S/N 9476N224FRVictor 93 LLC · Hummelstown, PABuilt 2008 · S/N 2953N224GRHaufe Nicole C · Madeira Beach, FLBuilt 2003 · S/N 0626N224HAMoser Myron · Chanhassen, MNBuilt 2025 · S/N 10954N224JC109 Ventures & Agency Services Inc · Glenburn, MEBuilt 2004 · S/N 0914N224JF224jf LLC · Waterford, MIBuilt 2006 · S/N 2031N224JGGuillory Mark T · Pineville, LABuilt 2004 · S/N 1013N224JKBrown Peter · Leavenworth, WABuilt 2018 · S/N 1660N224JMHip Flights LLC · Avon, COBuilt 2017 · S/N 1640N224KAChambers William Melvin Jr · Azle, TXBuilt 1979 · S/N 21063812N224KGRavin Group LLC · Orlando, FLBuilt 2012 · S/N 0312N224KRJds Holdings LLC · Oneida, TNBuilt 2002 · S/N 0179N224LRCamp95 Enterprises LLC · Wheeling, WVBuilt 2002 · S/N 0155N224LWVedda Aviation Group LLC · Cleveland, OHBuilt 2012 · S/N 0293N224LZMazzia Aviation Partners LLC · Alpine, WYBuilt 2007 · S/N 2767N224MHFeely Daniel R · Pasadena, CABuilt 1978 · S/N P21000089N224MVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1922N224NCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11608N224NHLola Leasing LLC · Sugar Land, TXBuilt 2009 · S/N 3569N224NXNexair Avionics LLC · Plymouth, MABuilt 2002 · S/N 0170N224PBDeaux James · Collierville, TNBuilt 2006 · S/N 1754N224PCCarlson Craig B Trustee · Los Altos, CABuilt 2018 · S/N 4655N224PFKurrle Ryan J · Austin, TXBuilt 2006 · S/N 1917N224PJLeng Jason W · Chehalis, WABuilt 2006 · S/N 2281N224PKValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 21064016N224PVTrigo Air LLC · Madera, CABuilt 2015 · S/N 1226N224RJDuke Mfg Of Florida LLC · Saint Louis, MOBuilt 2013 · S/N 4027N224RTIronwood Aviation LLC · Boerne, TXBuilt 2008 · S/N 3268N224RWNomad Air LLC · North Bend, WABuilt 2005 · S/N 1595N224SJPrestige Aircraft LLC · Madison, WIBuilt 2003 · S/N 0705N224SRRaffo Christopher Stephen · Potomac, MDBuilt 2006 · S/N 2172N224STB & G Aviation Enterprises LLC · Lilburn, GABuilt 2004 · S/N 0882N224SYMrc1 LLC · Bernie, MOBuilt 2002 · S/N 0184
Back to AD 2012-10-13