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.

N242SRVelocity Air Group LLC · Missoula, MTBuilt 2006 · S/N 2002N242SVDudek David Michael · New Baltimore, MIBuilt 2021 · S/N 5133N242TMCirco Industries LLC · Belle Chasse, LABuilt 2006 · S/N 2233N242TVIpsbs Managed Services LLC · Knoxville, TNBuilt 2024 · S/N 10130N242VBThor Aviation LLC · Key Largo, FLBuilt 2026 · S/N 11271N24365Zaisan Group LLC · Las Vegas, NVBuilt 2018 · S/N 1764N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782N243CHHartz C M · Key Largo, FLS/N 3369N243EHeads Steel Service Inc · Portland, TNBuilt 2024 · S/N 9848N243JBS & W Air LLC · Lawndale, CABuilt 2016 · S/N 1406N243LPKeaton Josh Trustee · Grants Pass, ORBuilt 2026 · S/N 11489N243RWN243rw LLC · Dayton, OHBuilt 2023 · S/N 9320N243WERap Aviation LLC · Dalhart, TXBuilt 2018 · S/N 1785N243WTWdt Aviation LLC · Colonial Beach, VABuilt 2024 · S/N 10164N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284N244AHLico LLC · Cedar Rapids, IABuilt 2006 · S/N 1915N244BWVan Diepen Enterprises LLC · Reno, NVBuilt 2017 · S/N 1505N244EVVezzetti Eugene · Houghton, MIBuilt 2006 · S/N 1841N244GObrien Michael Timothy · Corpus Christi, TXBuilt 1999 · S/N 01N244GMJsab Capital Holdings LLC · San Diego, CABuilt 2022 · S/N 8657N244HMHuneycutt Hawell C · Mooresville, NCBuilt 2006 · S/N 1955N244MBMunoz Santiago J · Kimberton, PABuilt 2005 · S/N 1426N244PVGarrett Air Holdings LLC · Mc Henry, MDBuilt 2016 · S/N 4392N244SCGiacometto John · Stevensville, MTBuilt 2004 · S/N 42047N244T727 Investments LLC · Lincoln, NEBuilt 2001 · S/N 0045N244TATma Glacier Ventures LLC · Whitefish, MTBuilt 2011 · S/N 0138N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294N2458RKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2004 · S/N TH-2089N245CPAir Jayhawk LLC · Houston, TXBuilt 2008 · S/N 3074N245DBVangundy R Eric · Chapin, ILBuilt 2005 · S/N 41102N245KMFm Air LLC · Wolcott, CTBuilt 2020 · S/N 4967N245MVShamrock Air LLC · Hingham, MABuilt 2025 · S/N 10649N245PMagruder Adam · Westcliffe, COBuilt 2004 · S/N 1204N245TSTexas Recreational Aircraft Club Inc · Houston, TXBuilt 2000 · S/N E-3318N245WCAbsolutes LLC · Arlington, VABuilt 2026 · S/N 11363N245WPEberhard Air LLC · Venice, CABuilt 2019 · S/N 4840N245ZMentor Aviation Inc · Goshen, INBuilt 1957 · S/N 144095N2466GIreland Jeffrey L · Shobonier, ILBuilt 2004 · S/N 1244N2468SStolen Hours LLC · Sanford, NCBuilt 2004 · S/N 1090N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841N246BJJas Aviation LLC · East Hartford, CTBuilt 2005 · S/N 1438N246CMHarmon David · Abilene, TXBuilt 2013 · S/N 3929N246CRBcah LLC · Scottsdale, AZBuilt 2017 · S/N 1493N246CVStatus Aviation Group LLC · Red Lodge, MTBuilt 2024 · S/N 9901N246DBOps Check LLC · Niceville, FLS/N 2704N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065N246EGRosen Gary J · Manchester, MABuilt 2025 · S/N 10594N246EMRjmr Capital Holdings LLC · Tyler, TXBuilt 2020 · S/N 4913N246GMSky Scrapers LLC · Derry, NHBuilt 2002 · S/N 0260N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355
Back to AD 2012-10-13