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.

N4ZYValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 1502N5000CFly Right LLC · Burlington, WIBuilt 2004 · S/N 0803N5000JProsperity Hospitality Management LLC · Lake Charles, LABuilt 2011 · S/N 0192N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N5005JDowding Industries Inc · Eaton Rapids, MIBuilt 1974 · S/N 310R0129N5009UOrca Flight LLC · Keaau, HIBuilt 2004 · S/N 0847N500AWMcnulty Kim E · Tehachapi, CAS/N 310R0077N500BAKw Plastics · Troy, ALBuilt 1997 · S/N TH-1814N500BMHawkwell Aviation LLC · Stillwater, OKBuilt 1982 · S/N TJ-418N500CHAchiro David P · Truckee, CABuilt 1976 · S/N 310R0734N500CMM & M Aviation LLC · Portsmouth, NHBuilt 1979 · S/N E1505N500CPEcho Acquisitions LLC · Dover, DEBuilt 2007 · S/N 2636N500CTLac Aero LLC · Liberal, KSBuilt 1981 · S/N 340A1236N500EBKaizen Aircraft Holdings LLC · Kalispell, MTBuilt 1977 · S/N 340A0287N500GGSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1990 · S/N E-2564N500HBN500hb LLC · Branchville, NJBuilt 2006 · S/N 1745N500QVJands LLC · Broken Arrow, OKBuilt 1979 · S/N 340A0699N500RCWright Mason · Henderson, NVBuilt 2005 · S/N 1680N500TLSententia LLC · Highland Park, ILBuilt 1999 · S/N TH-1890N500WN500w LLC · Ashburn, VABuilt 2005 · S/N E-3630N500WPWelker Franklin W · Agoura, CAS/N EA-582N501CGCirrus Flyers LLC · Gilbert, AZBuilt 2016 · S/N 4358N501DCExecutive Aviation LLC · Peoria, AZBuilt 1981 · S/N 340A1267N501HRAcross America Aviation LLC · Moreno Valley, CABuilt 2025 · S/N 10506N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21N501NANasa Langley Research Center · Hampton, VABuilt 2001 · S/N 0012N501PFTraumflieger LLC · Lancaster, PABuilt 2001 · S/N 40021N501PTJe Air 2 Corp · Wilmington, DEBuilt 2014 · S/N 4076N501PXMo Flying LLC · Fredericktown, OHBuilt 2016 · S/N 4313N501SFNomarco Inc · Woodburn, ORS/N 21061808N5023FCharlie Tango Enterprises LLC · Newport Beach, CABuilt 2004 · S/N 0842N5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLBuilt 2001 · S/N EA-677N5026VPiland Kenneth Eldon Jr · Carlsbad, CABuilt 1975 · S/N 21060822N502BELagniappe Cirrus Air LLC · Destin, FLBuilt 2025 · S/N 10781N502BPValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11325N502BWRomero Leasing Inc · Stuttgart, ARBuilt 1992 · S/N E-2716N502BZBirchfield Randy R · Wakeman, OHBuilt 2005 · S/N 1485N502CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1149N502RRHogan Aviation LLC · Park City, UTBuilt 2021 · S/N 2315N502SRRegistered aircraftBuilt 2007 · S/N 2460N5030SPolaris Fire Protection Inc · Fernandina Beach, FLBuilt 2004 · S/N 0827N5037QSayler Ben · Thief River Falls, MNBuilt 1971 · S/N 340-0012N5038JKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 310R0158N503ATRegistered aircraftBuilt 1975 · S/N 21060924N503BNAllegrezza Fred · Line Lexington, PABuilt 2005 · S/N 1276N503CDLagade Marco C · Lake Mary, FLBuilt 2004 · S/N 0909N503RAAirplanes And Coffee LLC · Kalispell, MTBuilt 2001 · S/N 40024N503SMTyler Lauren M · Ticonderoga, NYBuilt 2022 · S/N 8791N503WKAnimal Aviation LLC · Nashville, TNBuilt 2020 · S/N 4980N5047JAir Transport Arm Of Christ Inc · Hurst, TXBuilt 1975 · S/N 310R0167
Back to AD 2012-10-13