AD 2012-19-01

Registered aircraft · 51,501

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

N105NABond Gary G · Harvest, ALBuilt 1978 · S/N AA5B-1016N105NRState Of Minnesota · Grand Rapids, MNBuilt 2024 · S/N T20609780N105RCOlds Rodger C · Prescott Valley, AZS/N 3201N105RJSell Shannon Carl · Hoschton, GABuilt 2014 · S/N 3225N105RZHinson Neal · Lincoln, CABuilt 2003 · S/N 24527N105TCMark Johnson And Sons Plumbing LLC · Ruston, LABuilt 1979 · S/N 32-7940163N105TLSlay Brothers Enterprises LLC · Winter Haven, FLBuilt 2003 · S/N T18208213N105UTobago Six Inc · Bellevue, WAS/N 591N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104N1061QLbdd Enterprises 61q LLC · Pittsburgh, PABuilt 1977 · S/N 32-7200015N10624Daytona Aircraft Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9825N1062UNathan John K · Seabrook, TXS/N 32-40070N10632Skyblue Aviation Cr Inc · Merritt Island, FLBuilt 2007 · S/N 17281431N1063BFlat Earth LLC · Kalispell, MTBuilt 1958 · S/N 1290N1063CJim Johnson Nissan Inc · Bowling Green, KYBuilt 2006 · S/N 3257440N1063GDykhoff David C · Colorado Springs, COBuilt 2002 · S/N 80722N1063LWjm Aviation LLC · North Wales, PABuilt 2006 · S/N 2843644N1063QRussell Construction Co · Douglas, WYBuilt 1977 · S/N 32R-7780221N1064GAnding Jay B · Bryan, TXBuilt 1979 · S/N 5007N1064SSterling Smkr3 LLC · Oklahoma City, OKBuilt 2007 · S/N 4636411N1065DN1065d Mirage LLC · Rockville, MDBuilt 2006 · S/N 4636401N1065SGiacobbe Francesco · Severna Park, MDBuilt 1994 · S/N 27-0187N1065WCartwright Alexander Brooks · New Paris, INBuilt 1994 · S/N 27-0188N10662Momin Ahmed H · Sugar Land, TXBuilt 2005 · S/N 18281577N1066BWexhler David R Trustee · Carlsbad, CABuilt 2006 · S/N 3257443N1066CGullett Steve L · Bethel, OHBuilt 1958 · S/N 1337N1066ERising Skies LLC · Carefree, AZFirst renewal noticeBuilt 2006 · S/N 3246244N1066LMensing Roger G III · Sarasota, FLBuilt 1975 · S/N 659N1066SOmll Investments LLC · Ponte Vedra Beach, FLBuilt 2007 · S/N 3257457N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204N1068CGunlock Michael G · Boulder, COBuilt 2008 · S/N T18208822N1068EHafford Jay T · Stevenson, WAS/N 253-77N1069XEntelechy One LLC · Wichita, KSBuilt 1975 · S/N 32-7540134N106ACUpside Down Vt LLC · Milton, VTS/N 648-91N106AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2001 · S/N 17281055N106ATLichtman Aaron Marcus · Baltimore, MDS/N 32R-7780326N106BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843582N106BDLemons Brooks D · Visalia, CABuilt 2003 · S/N BR001N106BHSparebanc LLC · Appleton, MNBuilt 2002 · S/N 0013N106BSFox Whiskey Inc · Wilmington, DEBuilt 2007 · S/N T18208746N106CBRegional Appraisal Services Inc · Stone Mountain, GABuilt 1972 · S/N 73-31046N106CMStringer Tabb · Anacortes, WABuilt 2002 · S/N 0011N106DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881911N106EBBryan Gordon · Gilbert, AZBuilt 1997 · S/N 384-97N106EMVenture West LLC · Mesa, AZBuilt 1977 · S/N 28-7790460N106ETFairmont State University · Fairmont, WVBuilt 2000 · S/N 172S8563N106FI A Lele LLC · Great Falls, VAS/N 592N106FCFolden Holdlings LLC · Jonesboro, ARBuilt 2012 · S/N 13399N106FMGroner Michael F · Hicksville, NYBuilt 1978 · S/N 28-7990199N106FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1978 · S/N 3305
Back to AD 2012-19-01