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.

N333NYAvery Anne Leasing LLC · Rocky Point, NYBuilt 2016 · S/N 4373N333PSDoran Jeffrey T · Westerville, OHS/N 21060834N333PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 414A0525N333PXTime Investment Corp · Greenville, NCBuilt 2011 · S/N 3791N333QKPcg Aviation LLC · Charleston, SCBuilt 2025 · S/N 11014N333RDConn Aviation LLC · Millersburg, OHBuilt 2020 · S/N 2161N333REM I Aviation Inc · Juda, WIBuilt 1980 · S/N E-1737N333RFQualitair Lc Trustee · MichelstadtBuilt 1976 · S/N TJ-92N333RYZ2 Aviation LLC · Sausalito, CABuilt 2025 · S/N 10809N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779N333UDSpecialty Aero LLC · Seattle, WABuilt 1981 · S/N 340A1256N333VSFgc Corrmed Aero Inc · Benton, KYBuilt 2023 · S/N 9200N333WSMuller Gabriel J · Leesburg, VABuilt 2004 · S/N 0906N333WVSilverstein Sam III · Charleston, WVBuilt 2012 · S/N 200N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739N3349JRegistration Pending · Quincy, OHRegistration pendingS/N T18803632TN334DATwo Knuckleheads & An Airplane LLC · Georgetown, TXBuilt 2009 · S/N 3396N334FLChampionx LLC · Sugar Land, TXBuilt 2004 · S/N 290334N335ASeals Richard S · Key Colony Beach, FLBuilt 2006 · S/N 2288N335BDSunset Equity Partners LLC · Culver City, CABuilt 2021 · S/N 2391N335CMPura Plastic Surgery LLC · Doral, FLBuilt 1980 · S/N 414A0418N335CPMcbride John F Jr · Billerica, MABuilt 2008 · S/N 3250N335DDJab Aviation Inc · Wilmington, DEBuilt 1980 · S/N 335-0049N335KHSerafini Transportation LLC · Ringwood, NJBuilt 1979 · S/N 335-0025N335PElvin Robert Brian · Grove, OKBuilt 1996 · S/N E-3005N335PCOcow LLC · Jenks, OKBuilt 1980 · S/N 335-0053N335PGSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1504N335PW335 Leasing LLC · Englewood, COS/N 335-0011N335RAirdocs LLC · Atlanta, GABuilt 2000 · S/N E-3335N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413N335SHM&S Industrial Wholesale LLC · South Pittsburg, TNBuilt 2022 · S/N 8781N335SMMf Property Management LLC · Hattiesburg, MSBuilt 1979 · S/N 3350020N335TJYork Michael · Reston, VABuilt 1979 · S/N 335-0012N33633Valiair Lc Trustee · Casper, WYBuilt 2013 · S/N 0671N336BWright Brothers Aero Inc · Vandalia, OHBuilt 2006 · S/N 2049N336CABergeron Machine Shop Inc · Abbeville, LABuilt 1998 · S/N EA613N336CBBeechair LLC · Helena, MTBuilt 2002 · S/N E-3431N336HPChs Acquisitions Inc · Dallas, TXBuilt 1989 · S/N CE1312N336HTRegistered aircraftBuilt 2019 · S/N 4801N336MTNorth Peak Aviation LLC · Waunakee, WIBuilt 1999 · S/N E-3265N336PWCajan LLC · Kings Mountain, NCBuilt 1982 · S/N EA-297N336RDByone Steve · Natchitoches, LABuilt 1996 · S/N E-3008N336RWBe5816 LLC · Simi Valley, CABuilt 2005 · S/N E-3636N337ARRegistration Pending · Medford, ORRegistration pendingBuilt 1955 · S/N G-269N337CHAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701836N337EEAmpaire Inc · Long Beach, CABuilt 1974 · S/N 33701600N337GMRegal Air Partners Sr22t LLC · New Iberia, LABuilt 2026 · S/N 11185N337GVVenturino Lee Angelo Trustee · Kure Beach, NCBuilt 2013 · S/N 3928N337RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0869
Back to AD 2012-10-13