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.

N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214N78WWPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N TH-1747N79007Hardy Robert C · Plantation, FLBuilt 1997 · S/N ES-022N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620N7912QHagan David · Overgaard, AZBuilt 1969 · S/N 401B0012N7913QBrown Kevin B · Eureka, MTBuilt 1969 · S/N 401B0013N7916CEchelon Capital Aviation LLC · Palo Alto, CABuilt 2017 · S/N 1529N791BBG-4 Aviation LLC · Delaware, OHBuilt 2014 · S/N 0906N791GTGolf Tango Aviation 2 LLC · Johns Creek, GABuilt 2022 · S/N 2490N791KDKrupa Rafal · Hampstead, NCBuilt 2004 · S/N 1143N791LHFancy Dog Aero LLC · East Wakefield, NHBuilt 2005 · S/N 1739N791SDSeery Loren · Spokane, WABuilt 2018 · S/N 1830N7920JClear Creek Medical Corp · Arcata, CABuilt 2015 · S/N 1023N792JHElgee Aviation LLC · Fairfield, NJBuilt 2001 · S/N TH-1988N792PGWestchester Airplane Rental II LLC · Larchmont, NYBuilt 2009 · S/N 3372N792PS792ps LLC · Franklin, TNBuilt 2006 · S/N 1872N792SDSnoopdoodle Air LLC · Plano, TXBuilt 2020 · S/N 2074N792SRBest22 LLC · Phoenix, AZBuilt 2007 · S/N 2792N792TMWalk On Holdings LLC · Hattiesburg, MSBuilt 2018 · S/N 4721N79336Yaggie Allen · Wahpeton, NDBuilt 2005 · S/N 29-0379N793CDRbj Tn Holdings LLC · Cleveland, TNS/N 1099N793JHHandmade Wings LLC · Covina, CABuilt 2022 · S/N 8564N793KBRyal Holdings LLC · Jamestown, CABuilt 2007 · S/N 2749N793LMJohnson Roger C · Lake Havasu City, AZBuilt 1979 · S/N D-10300N793MSLeblanc Paul W · Wapakoneta, OHBuilt 2012 · S/N ES-075N794ABKodiak Brands Inc · Fairview, TXBuilt 2024 · S/N 9882N794LBLb Aviation LLC · Norma, NJBuilt 2024 · S/N 10369N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098N795AMBoone Aviation Services LLC · Winston Salem, NCBuilt 2004 · S/N 0997N795ATWarbirds-3 LLC · Kalispell, MTBuilt 2023 · S/N 9192N795EEHummingbird H2 LLC · Amarillo, TXBuilt 2007 · S/N 2804N795SCN795sc LLC · Byron Center, MIBuilt 2020 · S/N 2053N7969QBadenhope John R · Greeneville, TNS/N 401B0109N796PGSaco Leasing LLC · Dunwoody, GABuilt 2008 · S/N 3348N797BTCollins Jeffery Scott · Fort Myers, FLBuilt 2002 · S/N 0340N797CDPhronesis LLC · Tucson, AZBuilt 2006 · S/N 1897N797CKYale Aviation LLC · Ariel, WABuilt 2018 · S/N 1694N797EECoast To Coast Restoration LLC · Theodore, ALBuilt 2022 · S/N 8517N797HGBearaire LLC · Fairport, NYBuilt 1984 · S/N 46-8408064N797JKReefbound Ventures LLC · Raleigh, NCBuilt 2025 · S/N 10818N797KABank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 0108N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119N797SMLowry Michael R · Los Altos Hills, CABuilt 2003 · S/N 0616N797SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2770N797TN797t Aviation LLC · Stanfield, NCBuilt 2003 · S/N 42031N797VTGrace Aviation LLC · Canton, GABuilt 2025 · S/N 10877N7981Amjem Aviation Holdings LLC · Aurora, OHBuilt 2025 · S/N 10993N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202N7989QLauritano Stephen G · Goodyear, AZBuilt 1971 · S/N 401B0208
Back to AD 2012-10-13