AD 2012-14-15

Registered aircraft · 832

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-14-15')
    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-14-15')
  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.

N138TTTtd Travel LLC · Terre Haute, INBuilt 2022 · S/N 2192N13PJcngx LLC · New York, NYBuilt 2022 · S/N 2156N13UARegistered aircraftBuilt 2022 · S/N 2205N1471RLendingclub 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 2428N151MVDkj Services LLC · Augusta, KSBuilt 2018 · S/N 1828N153LGRw Charter Services LLC · Hopkinsville, KYBuilt 2013 · S/N 1420N153XAllred Leasing LLC · Missoula, MTBuilt 2009 · S/N 1153N156SAStandard Aviation LLC · Memphis, TNBuilt 2017 · S/N 1760N158CCutter Flight Management Inc · Albuquerque, NMBuilt 2022 · S/N 2190N1600WFlattop Aviation LLC · San Francisco, CABuilt 2018 · S/N 1812N1621MLybl Air LLC · Billings, MTBuilt 2019 · S/N 1846N164CMaroon & Gold LLC · Albuquerque, NMBuilt 2009 · S/N 1074N164RDIsland Park Aviation LLC · Fargo, NDBuilt 2022 · S/N 2225N164SLife Flight Network LLC · Aurora, ORBuilt 2009 · S/N 1164N166AFGeiger Holdings Inc · Portsmouth, NHBuilt 2022 · S/N 2166N1677Le Loop LLC · Naples, FLBuilt 2017 · S/N 1677N16FCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2071N16HQ10ke LLC · Okeechobee, FLBuilt 2016 · S/N 1656N172AFDynasty Flight LLC · Portsmouth, NHBuilt 2022 · S/N 2172N173CBer Company LLC · Albuquerque, NMBuilt 2023 · S/N 2256N175WAOsprey Aviation LLC · Preston, IDBuilt 2017 · S/N 1750N177NXLebeouf Bros Towing LLC · Houma, LABuilt 2018 · S/N 1777N178CMaroon And Gold LLC · Albuquerque, NMBuilt 2024 · S/N 2358N178WFJb Air Holdings 1 LLC · College Grove, TNBuilt 2022 · S/N 2222N179ALBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 1779N17SEBeta Fleet LLC · South Burlington, VTBuilt 2011 · S/N 1322N180NGCwa LLC · Saint Louis, MOS/N 1800N183CGeorgia Air South Inc · Valdosta, GABuilt 2016 · S/N 1597N189AFRmz LLC · Portsmouth, NHBuilt 2022 · S/N 2189N1919Phase 2 Aviation LLC · Miami, FLBuilt 2019 · S/N 1919N191PEJmm Aviation LLC · Oakwood, GABuilt 2010 · S/N 1191N191PGDw Leasing LLC · Charlotte, NCBuilt 2018 · S/N 1775N1921UBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 2104N192CPaso Aviation LLC · Winsted, MNBuilt 2024 · S/N 2403N192CPRegistered aircraftBuilt 2014 · S/N 1509N1932HAirmax LLC · Waukee, IABuilt 2023 · S/N 2260N198TKEbac LLC · Wichita, KSBuilt 2010 · S/N 1198N19AEGbny LLC · Sheridan, WYBuilt 2024 · S/N 2429N1CWAircw LLC · Charlotte, NCBuilt 2017 · S/N 1705N200NPRhys Vineyards LLC · Woodside, CABuilt 2016 · S/N 1596N201SPColorado State Patrol · Denver, COBuilt 2008 · S/N 1059N202PEDc Ways LLC · Macon, GABuilt 2010 · S/N 1202N202TWTw Leasing LLC · Oxford, CTBuilt 2022 · S/N 2202N206AFGpfp LLC · Portsmouth, NHBuilt 2022 · S/N 2206N207NWNorthwest Concrete Products Inc · Woodward, OKBuilt 2020 · S/N 2007
Back to AD 2012-14-15