OpenAirDocs.org
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.

N2518HHakan Michael · Carpinteria, CABuilt 2005 · S/N 41079N251AAAys Aviation LLC · Charlotte, NCBuilt 2024 · S/N 9959N251CPBurshtan David H · Huntington Beach, CABuilt 2008 · S/N 3176N251DXFlight Advantage Inc · Hot Springs, ARBuilt 2005 · S/N 41068N251SBAvistar Aviation LLC · Brentwood, TNS/N 0213N2520CKrause Douglas R · Hinckley, OHBuilt 2005 · S/N 41516N2520SPeregrine Air LLC · Colorado Springs, COBuilt 2005 · S/N 41073N2521WPc Enterprise Holdings LLC · Penfield, NYBuilt 2005 · S/N 41514N2522FGentrius LLC · Austin, TXS/N 41049N2524GTgc Aviation LLC · Houston, TXBuilt 2005 · S/N 41515N2525KAvenue Enterprises Transportation LLC · Longboat Key, FLS/N 0890N2525VLow Ceiling Aviation LLC · Cincinnati, OHBuilt 2006 · S/N 2055N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803N2526BTimd Group USA Inc · Cheyenne, WYBuilt 2005 · S/N 41105N2526LQuest Aero LLC · Zeeland, MIBuilt 2004 · S/N 41035N2527ZQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 41502N25281Relair LLC · Conesus, NYBuilt 2005 · S/N 41088N2528DOlson Michael S · Ellsworth, KSBuilt 2005 · S/N 41523N2528TN2528t LLC · Norcross, GABuilt 2004 · S/N 41029N2529PMatera Management LLC · Spanish Fork, UTBuilt 2005 · S/N 41521N252CBVenture Aviation LLC · Spokane, WABuilt 2016 · S/N 1472N252FDCirrus Design Corp · Duluth, MNBuilt 2024 · S/N 10061N252LMForest Restoration Inc · Philomath, ORBuilt 2013 · S/N 0543N252MASbkb Aviation LLC · Henderson, NVBuilt 2006 · S/N 29-0425N252PDeck Air LLC · Kalamazoo, MIBuilt 2004 · S/N 1002N252SLone Peak Air LLC · Gillette, WYBuilt 1980 · S/N 340A0984N252SWSymns Robert A · Aguila, AZBuilt 1978 · S/N 21063029N25367Robinson Stephen C · Garrison, NDBuilt 2005 · S/N 41503N2538MWarren James Rent · Rapid City, SDBuilt 2005 · S/N 41081N2538SBarbo Walter A · Aurora, COBuilt 1976 · S/N 21061322N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078N2539TSouthwest Aircraft LLC · Fairacres, NMBuilt 1970 · S/N NAV-4-2539N2539XWhy Drive LLC · Houston, TXBuilt 2006 · S/N 42505N253AJLeikur Inc · Tulsa, OKBuilt 2024 · S/N 10204N253BCHolliman Enterprises Inc · Edmond, OKBuilt 2023 · S/N 9143N253CDAngell John C · Ann Arbor, MIBuilt 2003 · S/N 0448N253DLLa Boots Ventures LLC · Marksville, LABuilt 2010 · S/N 0039N253ESchnack Aviation LLC · Twin Falls, IDBuilt 2008 · S/N 3106N253FDMile High Aviation LLC · Farmingdale, NJBuilt 2024 · S/N 9845N253JSN253js LLC · Wilmington, DEBuilt 2017 · S/N 4566N253PZDidiergroup LLC · Orlando, FLBuilt 2018 · S/N 1728N253RLArs Automation Design Inc · Greensboro, NCBuilt 1980 · S/N EA-131N253SRDara Mortgage Inc · Las Vegas, NVBuilt 2006 · S/N 2034N253WCba Investments LLC · Kalispell, MTBuilt 2004 · S/N 0881N2540MGlobal Emergency Services LLC · Beaumont, TXS/N 41031N2541AEnergy307 LLC · Casper, WYBuilt 2005 · S/N 41085N2542TCavu Aviation LLC · Searcy, ARBuilt 2005 · S/N 41508N2544TSpindler Construction Corp · Logan, UTBuilt 2005 · S/N 41072N2544WJoseph Belew · Clarksville, TNBuilt 2005 · S/N 41530N2545BD & H Equities LLC · Helena, MTBuilt 2004 · S/N 41036
Back to AD 2012-10-13