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.

N302CPJbl Aviation Group Inc · Houston, TXBuilt 2008 · S/N 3226N302JDNeoair LLC · Kingfisher, OKBuilt 2025 · S/N 10423N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909N302RPMccollough Randy F · Belton, TXBuilt 2004 · S/N 41051N302SRRebel Aviation LLC · Ramsey, MNBuilt 2006 · S/N 2175N302TDFl370 LLC · Northbrook, ILBuilt 2006 · S/N 1780N3030DBoardwalk Management LLC · Kalispell, MTBuilt 1999 · S/N E-3230N3031QBrut N3031q · Los Angeles, CAFirst renewal noticeBuilt 1998 · S/N E-3196N3032LBlue Sky Air Ventures LLC · Wilmington, DEBuilt 1999 · S/N EA-632N3033BPalms Edward M · Greenwood Village, COBuilt 1998 · S/N TH-1869N3034CTyler Bonnie Flying LLC · Tyler, TXBuilt 1986 · S/N E-2341N3035WWorldwide Air & Sea Inc · Wilton, NHBuilt 1999 · S/N EA-635N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918N303ABMarc Inc · Bolton, MSBuilt 1981 · S/N T30300028N303AWCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11629N303BPMohan Anand · Vienna, VABuilt 2005 · S/N 1698N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068N303DWOredigger Air LLC · Highlands Ranch, COBuilt 2024 · S/N 10231N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KDTablerock Aviation LLC · Mccall, IDBuilt 2022 · S/N 8522N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223N303LMRegistered aircraftBuilt 2002 · S/N 40041N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290N303SRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 2420N303TTCoop Aero LLC · New Albany, MSBuilt 2001 · S/N E-3377N303ZZMartorello Aircraft Leasing LLC · Denver, COBuilt 2025 · S/N 10593N3042V3 Pandas LLC · Farmington, NMBuilt 1998 · S/N EA-622N30453Lehman Land Management LLC · Vernon, TXBuilt 1973 · S/N 21059923N3045TRegistered aircraftBuilt 1987 · S/N E-2369N3045YMassee Donald R · Riverside, CAS/N EA-623N3046DAldredge John F · Cornville, AZBuilt 1994 · S/N E-2866N3046KBas Part Sales LLC · Greeley, COBuilt 1987 · S/N E-2362N3049DAnchor Equipment Leasing LLC · Covington, KYBuilt 1998 · S/N TH-1873N304DMDelta Mike Inc Trustee · Wilmington, DEBuilt 2024 · S/N 9782N304WHLone Beech Enterprises LLC · Peachtree City, GABuilt 2003 · S/N 0717N30516J A Sutherland Inc · Ukiah, CABuilt 1973 · S/N 21059927N30530Banegas Jose C Zankiz · Fort Myers, FLBuilt 1973 · S/N 21059929N3054ANocek Aviation LLC · Skaneateles, NYBuilt 1998 · S/N E3201N3054RJamms Aviation LLC · Bedford, NHBuilt 1994 · S/N E-2879N3058ROn Top Aviation LLC · Salinas, CABuilt 1998 · S/N TH-1870N305APDoc Joey Inc · Wilmington, DES/N 0500N305BCProp & Wing Aviation Inc · Humble, TXBuilt 1982 · S/N CE-993
Back to AD 2012-10-13