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.

N222RTWyofly LLC · Lewes, DEBuilt 2018 · S/N 1702N222RWRegistered aircraftBuilt 2011 · S/N 3RX120N222SDSloan Kevin · Edmond, OKBuilt 1973 · S/N E-473N222SGPacific Aviation Aircraft Management Inc · Fresno, CAS/N 210-64410N222SRC & C Air LLC · Cumming, GAS/N 0858N222STEau Claire Aviation LLC · Eau Claire, WIBuilt 1976 · S/N 310R0679N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164N222TNTen Two Adventures LLC · Leadville, COBuilt 2016 · S/N 1356N222UWFlyin In Style LLC · Greenwood, MSBuilt 1979 · S/N EA-49N222VHDd Leasing LLC · Aberdeen, IDBuilt 2019 · S/N 1972N222VSCharlie Rogers Ford Inc · Dayton, TNBuilt 2000 · S/N 29-0222N222WMKjs Holdings LLC · Raleigh, NCBuilt 2023 · S/N 9057N222XJBismarck Aircraft Owners Llp · Mandan, NDBuilt 2016 · S/N 4325N222YYMerlin Aviation LLC · Fairfield, CTBuilt 2005 · S/N 1458N2230DHendricks Construction LLC · Phoenix, AZBuilt 1976 · S/N 18503053N2234QJocz Mike · Clifton, VAS/N 30-0052N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180N223BBN223bb LLC · Great Falls, VABuilt 2000 · S/N E-3340N223BMCirrus 801ca LLC · Port Angeles, WABuilt 2015 · S/N 4285N223CHHrm Ventures Inc · Welcome, NCBuilt 2025 · S/N 10848N223CWNorthern Cowboy Holdings LLC · Prior Lake, MNBuilt 2018 · S/N 1699N223DFOurcirrus LLC · Highlands Ranch, COBuilt 2022 · S/N 8927N223ERKern Delta Co LLC · Fresno, CABuilt 2007 · S/N 2658N223FDRegistered aircraftBuilt 2023 · S/N 9162N223FSTtr Air LLC · Mount Dora, FLBuilt 2025 · S/N 10536N223GBMain Line Aviation LLC · Haverford, PABuilt 2022 · S/N 8638N223GKGk Aviation LLC · Orlando, FLBuilt 2022 · S/N 8764N223GSN771cd LLC · Missoula, MTBuilt 2007 · S/N 42555N223HHMach Speed Properties LLC · Spiro, OKBuilt 2006 · S/N 2212N223HMRegistration Pending · Sag Harbor, NYRegistration pendingBuilt 2026 · S/N 11390N223KWMedic Choppers LLC · Springdale, ARS/N EA-382N223MKKaul Mahendra · Bainbridge Island, WABuilt 2004 · S/N 1003N223MRConderet LLC · New York, NYFirst renewal noticeBuilt 2006 · S/N 1760N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105N223RWRegistered aircraftBuilt 2010 · S/N 3442N223SBAdams Derek · Lexington, MABuilt 1981 · S/N TJ-339N223SCSurdex Corp · Chesterfield, MOBuilt 1973 · S/N U20601999N223TFMeadowlark Air LLC · Johnston, IABuilt 2011 · S/N 3814N223TNGeneral Aviation Modifications Inc · Ada, OKBuilt 2007 · S/N 2698N223TSJvgh LLC · Eastpoint, FLBuilt 2019 · S/N 4788N223TXBaron Logistics LLC · Metairie, LABuilt 2007 · S/N 2494N223VBJuliet Whiskey Aviation LLC · Davenport, IABuilt 2020 · S/N 2054N223WTDouble Barrel Roll LLC · Post Falls, IDBuilt 2014 · S/N 0744N2242WKikhtenko Dmytro · Horse Shoe, NCBuilt 2025 · S/N 10831N2244ASw Adventures LLC · Las Vegas, NVBuilt 2024 · S/N 10232N2244GRichards Christopher · Austin, TXBuilt 2015 · S/N 1222N22459Hatch Leasing Company LLC · Flagstaff, AZBuilt 1972 · S/N 21059754N2246HHanover Flying Club LLC · Mechanicsville, VABuilt 2014 · S/N 4127N2247RSkaggs Erik Jerome · Tupelo, MSBuilt 2017 · S/N 4534N2247SCarnes Andrew P · Wichita Falls, TXBuilt 1976 · S/N 21061191
Back to AD 2012-10-13