AD 2002-16-07

Registered aircraft · 985

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:2002-16-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:2002-16-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.

N173LMCopper City Aviation Services LLC · Bisbee, AZBuilt 2009 · S/N F-09-08-06N174LMRasmussen Gregory · Floyds Knobs, INBuilt 2009 · S/N F-09-08-07N175PMMoulton William M · Meredith, NHBuilt 2007 · S/N 1 MK 436CN1773CZollinger Duane C · Rittman, OHBuilt 2007 · S/N 05061742N177AXXim LLC · Columbia, MOBuilt 2010 · S/N 200.177N177BKThompson Bruce G · Ithaca, NYBuilt 2015 · S/N 1MK466CN178ABDawson Daniel D · Princeton, IABuilt 2009 · S/N 01061720-ESN17KLWiers Keith R · Saint Albans, MEBuilt 2004 · S/N SKR0207204N17VPAvstar Inc · Seattle, WABuilt 2016 · S/N JA433-01-15N181ARGodbout Raymond J · Gorham, NHBuilt 2026 · S/N 181N181QKoerner Michael S · Rch Palos Vrd, CABuilt 2004 · S/N 04-04-05N1826RHolsinger Kent H · Denver, COBuilt 2011 · S/N 1826N185TUAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2017 · S/N 185/USN187KCSampson Air Services LLC · Queen Creek, AZBuilt 2012 · S/N AC167N188RRStemen Randy · Canal Winchester, OHBuilt 1993 · S/N 0791107N18WCSale Reported · SigmaringenSale reportedBuilt 2000 · S/N 38N190GMMahon Gary · Winslow, ILBuilt 2015 · S/N 7269N1914WSmitherman Roger · Choudrant, LAS/N 2000N192TUIasco Flight Training Inc · Redding, CABuilt 2017 · S/N 192/USN1935CCarmean Todd R · Owasso, OKBuilt 2013 · S/N F-12-07-04N194ABBriese Ronald R · Brandon, WIBuilt 2001 · S/N SKR0112154N1950SLammers Robert K · Oostburg, WIS/N A096ULSN195EARegistration Pending · Orem, UTRegistration pendingBuilt 2023 · S/N VSWX121A0140N1969GTucker Patrick A · Hopkinsville, KYBuilt 2004 · S/N 679N1971PSebesta Kenneth D · Boston, MABuilt 2011 · S/N 015N1981BBurkhardt David A · Oregon City, ORBuilt 2012 · S/N 159N1985AJp Aero Holdings Inc · Kalispell, MTBuilt 2019 · S/N 315N199TUTwin Icarus LLC · Mount Juliet, TNBuilt 2017 · S/N 199/USN19VMRegistration Pending · Colorado Springs, CORegistration pendingBuilt 2007 · S/N 07SCO28N1BASeawings LLC · Saint Petersburg, FLBuilt 2021 · S/N 00140N1DLThunderbird Aviation LLC · Littleton, COBuilt 1999 · S/N 11-031N2006KHelicorp Mro LLC · Dover, DEBuilt 2025 · S/N 421/USN2018Experimental Aircraft Assn Inc · Oshkosh, WIBuilt 2018 · S/N 121100N202XSDurney Alan Nelson · Santa Clarita, CABuilt 2023 · S/N C0687N20386Burlingame Ralph H Jr · Mound, MNBuilt 2003 · S/N KB01-3-00007N204PHHartunian Robert T · Fawnskin, CABuilt 2025 · S/N 535N204RDMastropietro Richard · Aptos, CABuilt 1995 · S/N 10079N205DHPhelps Jay R · Somerville, ALBuilt 2009 · S/N 1MK 472CN206ZMVeterans Edge Aviation LLC · Las Vegas, NVBuilt 2018 · S/N 918 AT 912 LSAN208MBramlett David M · Tucson, AZBuilt 2002 · S/N 10021457N208XIdahoxray LLC · Saint Anthony, IDBuilt 2019 · S/N S70411072N20KFMorel Paul F · Locust Grove, GABuilt 2009 · S/N KBS080N2116MHenshaw Calvin T · Clermont, FLBuilt 2000 · S/N 110N211KAKlinefelter Kevin J · Bishop, CAS/N 01N211SFYuriy Koziy · Massapequa, NYBuilt 2007 · S/N 07SC062N212EASavage David · N Richlnd Hls, TXBuilt 2023 · S/N VSWX121A0143N212LHRegistration Pending · Wht Sphr Spgs, MTRegistration pendingS/N FCU050N212XWittstruck Ivan W Jr · Greeley, COBuilt 2018 · S/N 54218N2155AFerguson Darrell W · Acton, MEBuilt 2006 · S/N 1DK408CN215AAFinneyfrock Arthur · Huddleston, VAS/N 14/01
Back to AD 2002-16-07