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.

N777VVDeluxe 8 LLC · New Orleans, LABuilt 2014 · S/N 4068N777WECentral Texas Shuttle Service LLC · Wilmington, DEBuilt 2011 · S/N 0220N777WVIndependent Mortgage · Westlake, LABuilt 1996 · S/N TH-1784N777WXMullins William Scott · Senoia, GABuilt 2003 · S/N 0452N777XXAustex Aviation Group Inc · Austin, TXBuilt 2002 · S/N 40058N777YFLandsgaard Equipment Leasing LLC · Wellington, COBuilt 1989 · S/N E-2495N777YPTim Edwards Co LLC · Wilmington, DEBuilt 2005 · S/N 1299N77877Air Vector LLC · Bountiful, UTFirst renewal noticeBuilt 2010 · S/N 3713N7788HTeodoro Financial Group Inc · Mill Valley, CABuilt 1988 · S/N E-2436N778CAMas Aviation LLC · Laurel, MSBuilt 2011 · S/N 3760N778CWGarbati Thomas Jr · Waterford, CTBuilt 1981 · S/N U20606184N778DAT And S Capital Holdings LLC · Tampa, FLBuilt 2022 · S/N 8707N778DBHage Enterprises LLC · Portsmouth, NHBuilt 2024 · S/N 9997N778GTMckenna Equipment LLC · Casper, WYBuilt 2014 · S/N 0700N778KB618lb LLC · Knoxville, TNBuilt 2025 · S/N 11026N778MMTapley Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608012N778PZG3 Aviation LLC · Cranston, RIBuilt 2023 · S/N 9463N778TPMotleys Air LLC · Richmond, VABuilt 2021 · S/N 2378N778WTSky Ventures LLC · Plaistow, NHBuilt 2021 · S/N 2290N7797SBaker Brian · Stanton, TXBuilt 2003 · S/N 0765N7798NGebhard John M · Hartland, WIBuilt 1977 · S/N U20603718N7799RRice Kenneth L · Payson, AZBuilt 2011 · S/N L2K-126N779COweis Yaseen · Bellaire, TXBuilt 2003 · S/N 0444N779DBAirjohn LLC · Cheyenne, WYBuilt 1985 · S/N TJ-489N779GWBuzzard Flop Aviation LLC · Celina, TXBuilt 2024 · S/N 9938N779JWFaero LLC · Bakersfield, CABuilt 2019 · S/N 4797N779RJN779rj LLC · Centennial, COFirst renewal noticeBuilt 2017 · S/N 1507N779SRNorton Thomas W · Dayton, NVBuilt 2014 · S/N 0961N779TWClassic Flyers LLC · Indianapolis, INBuilt 2008 · S/N 3261N779WCLane William Michael · Green Bay, WIBuilt 2004 · S/N 1247N779WSCoeruleus Aviation LLC · Coeur D Alene, IDBuilt 2016 · S/N 1377N779ZSLumen Wings LLC · Seattle, WABuilt 2024 · S/N 9889N77ACEagle Aviation Consulting LLC · Wilmington, DEBuilt 1991 · S/N E-2675N77BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340A-0053N77BVRegistered aircraftBuilt 1979 · S/N P21000221N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646N77CKRaiz Coaching LLC · Fort Worth, TXBuilt 1976 · S/N 20700343N77CXAces High Aviation LLC · Tulsa, OKBuilt 2014 · S/N 4051N77DEHaag Michael E · Granite Bay, CABuilt 1987 · S/N 4608054N77EYMile 6 Aeronautics LLC · New Berlin, WIBuilt 2019 · S/N 1923N77GJSees Aviation Inc Trustee · CheltenhamBuilt 2005 · S/N 29-0356N77HCHlh Properties LLC · Cohutta, GABuilt 1998 · S/N E-3189N77HGMyles Offshore Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11401N77KDExcell Partners Inc · Tampa, FLBuilt 2020 · S/N 2133N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703N77LVAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N TJ-287N77LYLightyear Aviation LLC · Ivins, UTBuilt 2021 · S/N 2487N77NWRizor Justin · Phoenix, AZS/N TK-141N77PGJjo Aero LLC · Keller, TXBuilt 1991 · S/N E-2680N77PHRiddick Aviation LLC · Columbia, MOBuilt 2000 · S/N 29-0234
Back to AD 2012-10-13