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.

N77QBDeauxboys LLC · Menomonee Falls, WIBuilt 1976 · S/N 340A0120N77RASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 21063846N77RTBouchier Thomas B · Post, TXBuilt 1978 · S/N TJ-135N77ZMHp Aviation LLC · Little Falls, MNBuilt 2014 · S/N 0923N780AKZobo Enterprises LLC · Alameda, CABuilt 2020 · S/N 2173N780CDGreene James W · League City, TXBuilt 2004 · S/N 1202N780JBAc22 LLC · Los Angeles, CABuilt 2013 · S/N 0495N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N780MDBerchiatti Geno R · Greenville, SCBuilt 2012 · S/N 0340N781CBMiller Charles Litle Trustee · Fresno, CABuilt 1977 · S/N 21062235N781CWSwf Investment Inc · San Francisco, CABuilt 2020 · S/N 2178N781DBCooper Roy · Lamesa, TXS/N P21000293N781JKJjk Aviation LLC · Harland, WIBuilt 2024 · S/N 10028N781PWPf Flyers Inc · Lavonia, GABuilt 2025 · S/N 10576N781SRRegistration Pending · Scottsdale, AZRegistration pendingBuilt 2008 · S/N 3310N781TCKeystone Ridge LLC · Colorado Springs, COBuilt 2006 · S/N 310014N781TH7817 LLC · Paradise Valley, AZBuilt 2019 · S/N 1843N782Dillon T34 782 LLC · Scottsdale, AZBuilt 1954 · S/N CG58EN7822MAero Rocket LLC · Las Vegas, NVBuilt 2005 · S/N 1722N782ASU Fly Aviation LLC · Campbell Hall, NYBuilt 2024 · S/N 10229N782CDArbuckle Roger · Greenville, KYBuilt 2005 · S/N 1691N782KJSrl Investments LLC · Boone, IABuilt 2005 · S/N 42083N782PGUltimax Aviation LLC · Columbus, OHS/N 3204N782RBSkarco LLC · Burlington, COBuilt 2021 · S/N 2434N782SRN782sr LLC · Missoula, MTBuilt 2007 · S/N 2884N783ABDelta Sr Nc LLC · Raleigh, NCBuilt 2025 · S/N 10557N783JMTime Machine LLC · Newton, ILBuilt 2018 · S/N 4635N783JR13 Aviation LLC · Chelan, WABuilt 1979 · S/N TJ-231N783KAKalex Enterprises Inc · Kingston, MABuilt 2024 · S/N 10298N783LXGenetech Animal Reproduction LLC · Purcell, OKBuilt 2021 · S/N 5097N783MKDove Si Trova La Stazione Di Tren LLC · Lafayette, CABuilt 2019 · S/N 1921N783RJMlc Aviation LLC · Sewickley, PABuilt 2015 · S/N 4291N783SRZarate LLC · Miami, FLBuilt 2007 · S/N 2783N7841QExigo Capital LLC · Miami Beach, FLBuilt 1973 · S/N 340-0222N7845QReading Jared · Uvalde, TXBuilt 1973 · S/N 340-0225N784CAEagle Capital Holdings LLC · Doylestown, PABuilt 2026 · S/N 11101N784CDRay Matthew C · Powell, OHS/N 1700N784CECharlie Echo LLC · Chico, CABuilt 2023 · S/N 9408N784MB784cb LLC · Las Vegas, NVBuilt 2025 · S/N 11056N784RJDove Street Associates LLC · Corona Del Mar, CABuilt 2014 · S/N 0705N784SECounty Management Inc · San Diego, CABuilt 2013 · S/N 0661N7855LJrm Equipment LLC · San Francisco, CABuilt 2006 · S/N 1951N7855ZRoskowski David · Charlestown, INBuilt 2005 · S/N 1629N7858PRegistered aircraftBuilt 1978 · S/N TJ-183N785BFlyright Ventures LLC · Las Vegas, NVBuilt 2023 · S/N 9196N785BBWarehouse #41 LLC · Wake Forest, NCBuilt 2023 · S/N 9429N785CDPresidio LLC · Manhattan, KSBuilt 2005 · S/N 1718N785MXtwa Cirrus LLC · Rio Verde, AZBuilt 2023 · S/N 9471N785SYAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2023 · S/N 9414N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207
Back to AD 2012-10-13