AD 2012-26-16

Registered aircraft · 1,377

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-26-16')
    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-26-16')
  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.

N124RCutter Flight Management Inc · Albuquerque, NMBuilt 2018 · S/N 1840N124UVGuardian Flight LLC · Lewisville, TXS/N 124N125BWBw Air LLC · Houston, TXBuilt 2022 · S/N 2208N125PZStraight Flight Nevada Commercial Leasing LLC · Sparks, NVBuilt 1998 · S/N 209N126ALShort Hop LLC · Bellevue, WABuilt 2007 · S/N 863N126TSLife Flight Network LLC · Aurora, ORBuilt 2009 · S/N 1111N1273ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 603N127TWTw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1574N129JWAir Methods LLC · Greenwood Village, COBuilt 1996 · S/N 129N129PKDashiell Corp · Houston, TXBuilt 2015 · S/N 1517N129TPHljh LLC · Corpus Christi, TXBuilt 2005 · S/N 629N12ARMermerus LLC · Branford, CTBuilt 2015 · S/N 1524N12DHClear Skies LLC · Lafayette, LABuilt 2010 · S/N 1210N12DZJmp Aircraft Service LLC Trustee · Wasilla, AKBuilt 2001 · S/N 390N12FAWilke Aviation Group LLC · College Station, TXBuilt 1995 · S/N 117N12JDYellow Transportation Services Inc · Milwaukee, WIFirst renewal noticeBuilt 1998 · S/N 228N12NFNiemann Aviation LLC · Quincy, ILBuilt 2021 · S/N 2128N12NVAir Ally LLC · Chisago City, MNBuilt 2018 · S/N 1801N12XFlying Goose LLC · Kennesaw, GABuilt 2022 · S/N 2204N12XNJdr Aircraft Company LLC · Tampa, FLBuilt 2020 · S/N 2042N131AFManufacturers And Traders Trust Co · Portsmouth, NHBuilt 2021 · S/N 2131N132ASFlight Level Services LLC · Danville, KYS/N 1319N132TPNational Eagle Aviation LLC · Grand Prairie, TXBuilt 2019 · S/N 1859N133PEEpps Air Service LLC · Atlanta, GABuilt 2008 · S/N 1018N134PFPeco Foods Inc · Tuscaloosa, ALBuilt 2014 · S/N 1491N134TWSrb Aviation LLC · Delmar, NYBuilt 2008 · S/N 1013N135PFPeco Foods Inc · Tuscaloosa, ALBuilt 2017 · S/N 1752N138PSEncore Asset Mgmt LLC · Newton, ILBuilt 2016 · S/N 1646N138TTTtd Travel LLC · Terre Haute, INBuilt 2022 · S/N 2192N13PJcngx LLC · New York, NYBuilt 2022 · S/N 2156N13UARegistered aircraftBuilt 2022 · S/N 2205N142LTJk Aviation LLC · Manteca, CAS/N 312N146PCLmco · Vandenberg Afb, CAFirst renewal noticeBuilt 1996 · S/N 146N1471RLendingclub Bank Na · Boston, MABuilt 2014 · S/N 1471N1477PWestern Aircraft Inc · Boise, IDS/N 1477N147AFShields Corp · Portsmouth, NHBuilt 2021 · S/N 2147N148CA&R Investment Property LLC · Albuquerque, NMBuilt 2021 · S/N 2146N149DLHls Air Inc · Poway, CABuilt 2008 · S/N 1049N149GTTenmile1 LLC · Rochester, MNBuilt 2024 · S/N 2428N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149N14RDLiftwing Aircraft Holdings LLC · Bellevue, WABuilt 2001 · S/N 384N151MVDkj Services LLC · Augusta, KSBuilt 2018 · S/N 1828N153LGRw Charter Services LLC · Hopkinsville, KYBuilt 2013 · S/N 1420N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153N153XAllred Leasing LLC · Missoula, MTBuilt 2009 · S/N 1153N156SAStandard Aviation LLC · Memphis, TNBuilt 2017 · S/N 1760N156SBSpark Aviation LLC · West Harrison, NYS/N 156N156WLCl 245 Partners LLC · Erie, COFirst renewal noticeS/N 245N158CCutter Flight Management Inc · Albuquerque, NMBuilt 2022 · S/N 2190N1600WFlattop Aviation LLC · San Francisco, CABuilt 2018 · S/N 1812
Back to AD 2012-26-16