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.

N337TMFowler James Md · Mcallen, TXBuilt 2011 · S/N 0160N338CPQualitair LLC Trustee · MichelstadtBuilt 2008 · S/N 3253N338D38 Delta Corp · Killington, VTBuilt 1987 · S/N E-2392N338DKUp Top Aviation LLC · Piedmont, CABuilt 2016 · S/N 1461N338TXBussin' Air LLC · San Antonio, TXBuilt 2023 · S/N 9383N33958Yoalz Inc Trustee · Wilmington, DEBuilt 2025 · S/N 10835N339APParalos Aviation LLC · Penngrove, CABuilt 2020 · S/N 2168N339CDMcwethy22 LLC · Woodstock, GABuilt 2004 · S/N 1107N339DGRegistered aircraftS/N P21000434N339DTGuzauff LLC · Katy, TXBuilt 2015 · S/N 4224N339MCWilbers Aviation LLC · Austin, TXBuilt 2020 · S/N 2169N339TMSoter Leasing LLC · Kalispell, MTBuilt 2026 · S/N 11243N339TSCapstone Aviation LLC · Siloam Springs, ARBuilt 2006 · S/N 3RX069N339WMFlying Frenchies LLC · Naples, FLBuilt 2024 · S/N 9850N339WSGolf Stream Aviation LLC · Mattoon, ILBuilt 2014 · S/N 0710N33ADSouthern Turf Services LLC · West Palm Beach, FLBuilt 1973 · S/N 414-0412N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632N33CFObx Boil Aviation LLC · Kitty Hawk, NCBuilt 2022 · S/N 8525N33GXSiman-Tov Yariv · Redmond, WABuilt 2004 · S/N 29-0333N33HCSmith Christopher J · Longwood, FLBuilt 2004 · S/N 0815N33HLKnudsen Russell G · East Troy, WIBuilt 1973 · S/N 340-0315N33JGCavu 1989 LLC · New Hope, PABuilt 2021 · S/N 5075N33KBRegistered aircraftBuilt 2026 · S/N 11263N33KKMcguiness Construction Inc · Ramona, CABuilt 1990 · S/N E-2528N33KXEasy Peasy Aviation LLC · Ava, MOBuilt 2021 · S/N 2447N33LFJbo Airventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 340-0352N33MHAkeyson Edward W · Durham, CTBuilt 1982 · S/N T30300076N33MWSackett Gary G · Millcreek, UTBuilt 2007 · S/N 2435N33PFNeed For Speed Aviation LLC · Charleston, SCBuilt 2007 · S/N 2572N33PMKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1977 · S/N TJ-78N33RHSteel Miles · Houston, TXBuilt 2006 · S/N L2K-258N33RJRomeo Juliet Explorations LLC · Dover, DEBuilt 2026 · S/N 11430N33SGMennella James E · Oklahoma City, OKBuilt 1980 · S/N EA-109N33SHDrl Baron LLC · San Augustine, TXBuilt 2001 · S/N TH-2007N33TVTgbde LLC · Fort Pierce, FLBuilt 2007 · S/N 2400N33UT402wd Holdings LLC · Corpus Christi, TXS/N 21061177N33VKEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1991 · S/N 005N33WKSager Earl Dwayne · Perryton, TXBuilt 1979 · S/N TJ-243N33WRWilson Aviation LLC · Addison, PAFirst renewal noticeBuilt 2013 · S/N 0586N33WSJak2 Properties LLC · Ocala, FLBuilt 2017 · S/N 4563N33WVInarayan Inc · Winter Park, FLS/N 414A0082N33ZGK&A Heel Hawk LLC · Camden, DEBuilt 2024 · S/N 10316N3404Renair LLC · Winter Garden, FLBuilt 2020 · S/N 2155N3405QHardin David A · Tukwila, WABuilt 1966 · S/N 320E-0005N3407CK&L Leasing And Investment LLC · Mountain Green, UTBuilt 1974 · S/N 340-0506N340ABBison Investment Advisors Inc · Lafayette, INBuilt 1978 · S/N 340A0471N340ADN89vy LLC · Benson, NCS/N 340-0369N340AGRicker David · Conway, ARBuilt 1973 · S/N 340-0205N340AHEden On Broad LLC · Cookeville, TNBuilt 1977 · S/N 340A0333N340AJListo Aviation LLC · Chelsea, ALBuilt 1980 · S/N 340A1040
Back to AD 2012-10-13