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.

N8154QShine Hugh D · Temple, TXBuilt 1990 · S/N E-2584N8155ASkylane Ventures LLC · Keizer, ORS/N 310R0025N815CDHotrod Aviation LLC · Greencastle, INS/N 0149N815DBR&R Daredevils LLC · Wilmington, DEBuilt 2011 · S/N 3743N815GBCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11603N815HCHci Leasing Inc · Merritt Island, FLBuilt 2004 · S/N 1199N815JDBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0543N815LNasty Rancher LLC · Alpine, WYBuilt 2021 · S/N 2388N815LAGarrettgobo LLC · Saint Augustine, FLBuilt 1994 · S/N E-2850N815MKEasley Michael · Colorado Springs, COBuilt 2004 · S/N ESSS-174N815PZ11 Papa Zulu LLC · Steamboat Springs, COBuilt 2020 · S/N 2154N8162DWc&R LLC · Austin, TXBuilt 1991 · S/N E-2589N8163FCalugar Ronald C · Bunnell, FLBuilt 1991 · S/N E-2590N8163RFoothills Insurance Services LLC · Marion, NCBuilt 2003 · S/N 0744N8163VPerleberg Patrick M · Cedar Grove, INBuilt 2003 · S/N 0748N8164FVander Ark Jan R Trustee · Chandler, AZBuilt 2003 · S/N 0749N8165EWw Air LLC · Templeton, CABuilt 1998 · S/N E-3193N8165HNext Centennial Holdings LLC · Alexandria, VABuilt 2003 · S/N 0747N8165QStewart Robert Page · Monroe, NCS/N E-2592N8166GRohrer John D · Belmont, CABuilt 1993 · S/N EA-546N8167AMagic Aviation LLC · Joplin, MOBuilt 1991 · S/N E-2594N8167KHues Oulton A · Norwood, MABuilt 1993 · S/N EA-547N8168FSnyder Jeffrey L · Clarkston, MIBuilt 1991 · S/N E-2596N8168QRucks Aviation LLC · Okeechobee, FLBuilt 2004 · S/N 0805N8168VLandau Stephen C · Whitehouse Station, NJBuilt 2003 · S/N 0790N816CDDodson International Parts Inc · Rantoul, KSS/N 0150N816GHSteim Joseph M · Shirley, MABuilt 1978 · S/N 310R1507N816JTRed Angel Wings LLC · Colorado Springs, COS/N 41058N816LATipuani Corp · Dover, DEBuilt 1994 · S/N E-2851N816LDJazz Aviation LLC · Largo, FLBuilt 2012 · S/N 3843N816LMKobylar Lester J · Greensboro, GABuilt 2000 · S/N 29-0250N816LNAircraft Partner Holdings Inc Trustee · BerlinBuilt 2021 · S/N 5030N816LTSix Lima Tango LLC · Zionsville, INBuilt 2003 · S/N 0511N816MCOghab LLC · Atlanta, GABuilt 2024 · S/N 10208N816MMFlight Dynamics LLC · Clifton, VABuilt 2022 · S/N 8797N816PPAia Alpha LLC · Henderson, NVBuilt 2024 · S/N 10266N816RJArkansasflyingdoc LLC · Benton, ARBuilt 2001 · S/N 0112N816RWMarco Ravace Aviation LLC · Biloxi, MSBuilt 2021 · S/N 2309N816SCFirst Hand Transportation LLC · Lake Orion, MIBuilt 2006 · S/N 1878N816SDCcr Inc · Tulsa, OKBuilt 2007 · S/N 2323N816SGViking Aviation LLC · Blue Mounds, WIBuilt 2025 · S/N 10875N816SRInalytix LLC · New York, NYBuilt 2019 · S/N 10135N8170AAlpha Aviation LLC · Springfield, MOBuilt 2003 · S/N 0745N8170EInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0809N8171GEdge Air LLC · Wilmington, DEBuilt 2003 · S/N 0751N8171PTravelplus LLC · Knoxville, TNBuilt 2004 · S/N 0797N8171ZRidgeline LLC · Helena, MTBuilt 1993 · S/N E-2785N8173MBrazos Air LLC · Mc Gregor, TXBuilt 2003 · S/N 0750N8174AHank'S Aviation LLC · Merrillville, INBuilt 2003 · S/N 0721N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635
Back to AD 2012-10-13