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.

N828PWSnowball Aviation LLC · Houston, TXBuilt 2017 · S/N 1635N828PZEzsp Capital Holdings LLC · Corona Del Mar, CABuilt 2024 · S/N 10059N828RJNielsen Ron E · Lindon, UTS/N 21063836N828RPUnique Aviation LLC · Charleston, ILBuilt 2017 · S/N 1642N828RRNorthern Lights Sc LLC · Wilmington, DEBuilt 2016 · S/N 4337N828SBEa Aircraft Lease LLC · Dayton, MNS/N EA-111N828SJXonk Holdings LLC · Fort Dodge, IABuilt 2017 · S/N 1580N828TMTaylor Aero LLC · Lewes, DEBuilt 2004 · S/N 0943N828TTLoud LLC · Carthage, NCBuilt 1994 · S/N TH-1729N828TXGoebel Construction LLC · San Antonio, TXBuilt 2024 · S/N 10151N828VTParque Colina LLC · San Antonio, TXBuilt 2009 · S/N 3587N828ZZFuture Flight LLC · Billings, MTBuilt 2013 · S/N 0605N8290EWb Aviation LLC · Belmont, MIBuilt 1993 · S/N E-2805N8290ULets Fly LLC · Fortson, GABuilt 1993 · S/N TH-1688N8292MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 21059292N8293MMaffett Properties LLC · Dublin, GABuilt 1993 · S/N E-2794N8293QBaker Marianne J · Raeford, NCBuilt 1976 · S/N U20603154N8296LRoth Vicki B · Bristow, OKBuilt 1993 · S/N E-2833N8296RPowell Franklin Travis · Lone Pine, CABuilt 1992 · S/N E-2763N8296UFritzinger Mark Thomas · Goldsboro, NCBuilt 1993 · S/N E-2828N8297ABonanza A36 LLC · Cedar Rapids, IABuilt 1992 · S/N E-2764N8299DB K A Air LLC · Kennett, MOS/N E-2812N8299WKj 422 LLC · Augusta, GABuilt 1993 · S/N E-2809N8299ZCoachair Inc · Groveland, CABuilt 1993 · S/N EA-545N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819N829BTEichstaedt Alessandro · Denver, COBuilt 2019 · S/N 2006N829CFKendrick Consulting LLC · Hayden, IDBuilt 2010 · S/N 3683N829CGRegistered aircraftBuilt 1986 · S/N 4608029N829CN3771r LLC · Lockport, NYBuilt 2011 · S/N 3764N829DXuno Group LLC · Fort Lauderdale, FLBuilt 2023 · S/N 9127N829DMValiair Lc Trustee · Casper, WYBuilt 2022 · S/N 8729N829DTMomentum Aviation LLC · Bogart, GABuilt 2024 · S/N 10293N829HSAero Systems Design Group LLC · North Reading, MABuilt 2020 · S/N 2170N829PKMainstay Distributing LLC · Norwalk, WIBuilt 2022 · S/N 8995N829RRaby Ron A · Portsmouth, NHBuilt 2005 · S/N ES-163N829RC829rc LLC · Lewes, DEBuilt 2018 · S/N 4725N829UMSlate Ridge LLC · Alpine, WYBuilt 2024 · S/N 10184N829WBlue Sky Transport LLC · Deland, FLBuilt 2005 · S/N 1407N82AUPappy John E · Keller, TXBuilt 2023 · S/N 9376N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064N82BVetted Air LLC · Saint Petersburg, FLBuilt 1991 · S/N E-2663N82CKBloxham Thomas L · Pleasant Hill, CABuilt 1997 · S/N E3096N82DHBonlori Aviation LLC · Ruston, LABuilt 2010 · S/N 0008N82DPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11554N82DSSiekmann David G · Scottsdale, AZBuilt 2025 · S/N 194N82ESkymaster Mods & Parts LLC · Castalian Springs, TNBuilt 1973 · S/N P3370126N82FGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2022 · S/N 9001N82GBAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 340A0463N82JRRoss Jerry Dean · Springfield, MOBuilt 2025 · S/N 10510N82LYFly Bye Holdings LLC · Dallas, TXBuilt 2025 · S/N 11032
Back to AD 2012-10-13