OpenAirDocs.org
AD 2012-01-07

Registered aircraft · 248

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-01-07')
    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-01-07')
  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.

N247WTHansen Kevin Lee · Island Park, IDS/N 0114603N24YDHezmalhalch Keith P · Napa, CABuilt 2007 · S/N 1DK427CN24YTBadger Air LLC · Wilmington, DEBuilt 2017 · S/N 125N258SGCircling Sky LLC · Reno, NVBuilt 2025 · S/N 12-058N262SCDearing Keven L · Buffalo Center, IABuilt 2007 · S/N S60011-043N2630CBrown Russell C · Howey In The Hills, FLBuilt 2005 · S/N 0020N2646CBrown Russell C · Howey In The Hills, FLBuilt 2004 · S/N 0017N2647CBrown Russell C · Howey In The Hills, FLBuilt 2001 · S/N 0016N2650CBrown Russell C · Howey In The Hills, FLBuilt 1994 · S/N 0019N271SFN291ag Co · Wilmington, DEBuilt 2013 · S/N M01050N277CGGuarno Adam · Milton, FLBuilt 2004 · S/N 1MK277CN278ADStemme LLC · Appleton, WIBuilt 2008 · S/N 11-122N280EPSiddoway Jeff DBA · Terreton, IDBuilt 2024 · S/N A443ULSN281KRAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2022 · S/N 12-047N290JJThompson James W · Bronwood, GABuilt 2007 · S/N 676N298BLAmbient Air Technologies LLC · Fort Collins, COBuilt 2017 · S/N 298/2017N29STShewmaker Air LLC · Bentonville, ARBuilt 2019 · S/N 12029N29WGClinton Peter C · Cheyenne, WYBuilt 2006 · S/N 1MK296CN300MJSnider Aaron Andrew · Hart, MIBuilt 1999 · S/N AC039N321HCLinda Vista Aviation Inc · West Palm Beach, FLBuilt 2015 · S/N 11-143N322PZUsibelli Joseph E · Fairbanks, AKBuilt 2013 · S/N 1LK573CN333VTCanfield Dan · Ephrata, WABuilt 1998 · S/N 11-013N334QHuitema Tom P · Portage, MIBuilt 2020 · S/N 1LK578CN339PDWhiteley James N · Reno, NVS/N 1MK437CN341CBBlue Sky Flyers LLC · Reno, NVBuilt 2011 · S/N 2011 1405N344WPPapa LLC · Eufaula, ALBuilt 2022 · S/N 12-044N356JJBarnes Justin · Belgrade, MTBuilt 2024 · S/N KA22031533N357KCMostrong Michael C · Martinez Lake, AZBuilt 2015 · S/N JA372-04-14N361EXHangar 36 · Batavia, OHBuilt 2017 · S/N H3-42-1630N363JAHeatwole Oren E · Dayton, VABuilt 2017 · S/N JA316-09-13N3663CLange Joseph M · Fort Garland, COBuilt 2016 · S/N 7-10503N377KMFrick Gary A Trustee · Marion, INBuilt 2017 · S/N 060N377WBG-Dawg LLC · Highlands, NCBuilt 2015 · S/N JA449-03-15N387NRegistration Pending · Leavenworth, KSRegistration pendingS/N 16095504N38PBExtreme Air LLC · Santa Barbara, CABuilt 2020 · S/N 12-032N396SFunfsinn John J · Peru, ILBuilt 2020 · S/N 08175411014N3993Registration Pending · Fort Worth, TXRegistration pendingBuilt 2019 · S/N 376N400SPKaplan Asher H · Tucson, AZBuilt 1999 · S/N 11-035N401HAKitty Hawk Flight School LLC · Nags Head, NCBuilt 1999 · S/N HAS001N402HAKitty Hawk Flight School LLC · Nags Head, NCBuilt 2004 · S/N HAS002N406WSMorris Milton L · Pierre, SDS/N 1706N40PBExtreme Air LLC · Santa Barbara, CABuilt 2018 · S/N 12-017N41089Rodewald Ryan · Umatilla, FLBuilt 2009 · S/N 1MK455CN414RHCity Of Tomball · Tomball, TXS/N M01147N416MGSportflight Inc · Laporte, INBuilt 2008 · S/N 16-08-4624N419PLHirschi Stephen T · Vernal, UTBuilt 2007 · S/N A241AN425PMMcwhirter Paul · Lafayette, CABuilt 2021 · S/N 12-038N4269GMoon Shannon M · Catawba, NCS/N 1DK413CN429RWDzyne Technologies · Foothill Ranch, CABuilt 2019 · S/N 12-026N43889Olson Perry D · Fort Lupton, COBuilt 2008 · S/N M02914SOHK0009
Back to AD 2012-01-07