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.

N410DRJmsat Corp · Moneta, VABuilt 1977 · S/N TK52N410HBJh Rfg6 LLC · Teton Village, WYBuilt 2020 · S/N 2123N410JCFbn Holding Corp · Larkspur, CABuilt 1986 · S/N 4608038N410JDN410jd LLC · Oneida, TNBuilt 2025 · S/N 11001N410KGGreylady Aviation LLC · Bellville, TXBuilt 2009 · S/N ES-014N410LJBednar David · Norwalk, IABuilt 1982 · S/N EA293N410MPGulf Horizon Ventures LLC · Tampa, FLBuilt 2021 · S/N 5005N410NFMurphy Aviation Inc · Gilroy, CABuilt 1978 · S/N 414A0102N410PCBohnert Matthew · Bend, ORBuilt 1976 · S/N TJ-48N410PPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3600N410RHHurst Randall · Corinth, TXBuilt 2007 · S/N L2K-276N410SMMartin Aviation LLC · Grandview, TXBuilt 2015 · S/N 1077N410SRBiondich Amy · Rubicon, WIBuilt 2006 · S/N 2138N410VVDaniels Mark A · Raleigh, NCS/N 3394N410WMFlying Life LLC · Middleburg, FLBuilt 1975 · S/N 310R0578N4111SKnowles Warren R · Ocean City, NJS/N TJ-4N4116GAcaats LLC · Queen Creek, AZBuilt 1977 · S/N 340A0288N411ABAmerican Time Machine LLC · Edmond, OKBuilt 1980 · S/N 414A0524N411APN411ap LLC · Independence, KSBuilt 2002 · S/N 0215N411BJclm Aviation LLC · Atlanta, GABuilt 2006 · S/N 1865N411DTSliwa Kevin Joseph · Fishers, INBuilt 2010 · S/N 3678N411EEVaini Marc · West Plains, MOBuilt 2005 · S/N 41100N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184N411EPRsbrm Aviation LLC · Lakewood, NJBuilt 2025 · S/N 10607N411GJGuardian Jet LLC · Guilford, CTBuilt 1990 · S/N E-2586N411GTTeam 646 LLC · Jupiter, FLBuilt 2005 · S/N 1714N411HZCedar Dix LLC · Lancaster, KYBuilt 2005 · S/N 1568N411JGKern County Aviation Leasing LLC · Bakersfield, CABuilt 1986 · S/N EA-461N411LGLover Girl Aviation LLC · Peachtree Corners, GABuilt 2021 · S/N 2426N411MARouse William J · Palm Springs, CAS/N 3496N411PKC C Owen Tile Co Inc · Jonesboro, GABuilt 2008 · S/N 3368N411RCLola Aviation LLC · Truckee, CABuilt 2022 · S/N 8943N411STwin Adventures LLC · Cincinnati, OHBuilt 1972 · S/N 340-0099N411SAMasdon Aviation LLC · Guntersville, ALBuilt 2006 · S/N 1967N411SESwm III Investment 1 LLC · Lubbock, TXBuilt 2014 · S/N 0897N411SKRiverside Aviation LLC · Fernandina Beach, FLBuilt 2017 · S/N 4582N411SRC1n Cirrus G3 LLC · Rockford, ILBuilt 2007 · S/N 2518N411THCrash Landers LLC · Webster, NYBuilt 2010 · S/N 0061N411TTRambod Marc · Taos Ski Valley, NMBuilt 1975 · S/N 21060861N411TXGilbert Ivory M · Bonita Springs, FLBuilt 2005 · S/N 29-0410N411UMEasy Wind LLC · Nashville, TNBuilt 2022 · S/N 8802N411VTvc Aviation Inc · Lebanon, OHBuilt 1973 · S/N 340-0250N411VGMontala Investments LLC · Montgomery, ALBuilt 1981 · S/N 414A0675N411VTFletcher Holdings Of Nc LLC · Winston Salem, NCBuilt 2002 · S/N 0393N411WBRiser Aviation LLC · Covina, CABuilt 2025 · S/N 10643N411YPPops Adventures LLC · Highland, UTBuilt 2025 · S/N 10581N4122PCloud Eight LLC · Los Altos, CABuilt 2023 · S/N 9394N4124WGeaux Automotive Advertising LLC · La Place, LABuilt 2000 · S/N TH-1943N4125GSeeding Operations And Atmospheric Research (Soar) · San Angelo, TXBuilt 1977 · S/N 340A0297N412AGAme Aviation LLC · Denver, COBuilt 2021 · S/N 2331
Back to AD 2012-10-13