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.

N216EBrede Brian K · Lincoln, NEBuilt 2024 · S/N S01912SOHK 0395N216PMBolinger Andy L · La Follette, TNBuilt 2012 · S/N V00065N216TUTecnam US Inc · Sebring, FLS/N 216/USN219GHBurrichter Steven · Scottsdale, AZBuilt 2010 · S/N 05080007N220TSCondor LLC · Ponte Vedra Beach, FLBuilt 2013 · S/N 025N221LSWebb Jeffrey J · Fair Play, SCBuilt 2013 · S/N F-13-02-02N221SHSewell David E · Humble, TXBuilt 2023 · S/N 142N221TCSchollmeyer Mike D · Dunn Center, NDBuilt 2007 · S/N 47/2002N221WUtset Anthony · Okeechobee, FLBuilt 2013 · S/N M00982N222DPatterson Lawrence Jr · Tampa, FLBuilt 2005 · S/N 1MK378CN222SCKathryn E Theiss Phd · Portland, ORBuilt 2007 · S/N 07SC068N222YBCameron Chad E · Box Elder, SDS/N 1LK545CN223PFScout Aerospace LLC · Greensboro, NCBuilt 2019 · S/N 1002 AT 912 LSAN223SThurber Raymond L · White Lake, MIBuilt 2007 · S/N 07SC067N226HCSafeway Aviation LLC · Richmond, TXBuilt 2016 · S/N 120N228BMC2s2 Partners LLC · Chesapeake, VABuilt 2023 · S/N 391/USN228FTCole Matthew Dewayne · Trenton, GAS/N A-115N228XMidgley Edward S · Sugar Grove, ILBuilt 2014 · S/N 085N229DCBowen David W · Tucson, AZBuilt 1996 · S/N 04960707N22ZLDalley Eric · Salt Lake City, UTBuilt 2023 · S/N C0686N23183Nauti Services Inc · West Park, FLBuilt 2006 · S/N UA001N232JWElswick Theodore B · Fernley, NVBuilt 2007 · S/N 07SC044N232PMHangar 23a LLC LLC · Woodbury, MNBuilt 2004 · S/N 3543N232SSHaynes John H · Gainesville, GABuilt 2015 · S/N JA 327-11-13N2337RHigh Flight Services Inc · Miami, FLS/N UA002N2341RMagniflight LLC · Pensacola, FLBuilt 2020 · S/N 24192284N234HWThooft Marlowe · Russell, MNBuilt 2012 · S/N JA262-03-12N234NXRising Wings Aviation Inc · Casper, WYBuilt 2018 · S/N 234/USN236SCHall Richard G · Egg Hbr Twp, NJBuilt 2007 · S/N 07SC078N237AECollins Alan M · Delta, COBuilt 2011 · S/N S70204-011N239AWBrown Daniel J · Grinnell, IABuilt 2008 · S/N SKR 96555N240TUTecnam US Inc · Sebring, FLBuilt 2017 · S/N 240/USN241AVRegistered aircraftBuilt 2022 · S/N AA2A00190SLSAN241GGThompson Tom III · Byers, COBuilt 2012 · S/N 24127574N242TALevy Robert · Staunton, VABuilt 2012 · S/N 068N2430RGreat Lakes Flyer LLC · Waxhaw, NCBuilt 2022 · S/N AC-246N245TASaltair LLC · Salt Lake City, UTBuilt 2014 · S/N 135/USN247MVSpitfire Ventures LLC · San Antonio, TXBuilt 2017 · S/N AC188N247WTHansen Kevin Lee · Island Park, IDS/N 0114603N2487NMacias Martin V · Yuma, AZBuilt 2007 · S/N A085ULSN2489YKlimenko Eugene · Merrill, WIBuilt 2002 · S/N 0001N248TATumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2015 · S/N 148/USN2491UOddie James W Trustee · Cerritos, CABuilt 2007 · S/N M02XXXSOHK0015N2495XYoder John D · Centreville, MIS/N A083ULSN2497HDuke David O · Arroyo Grande, CABuilt 2006 · S/N T06075N249MSBodrie Sean · Brighton, MIBuilt 2009 · S/N 0807478N24BZTwo Calf Cattle Company LLC · Winifred, MTBuilt 2015 · S/N JA447-03-15N24ESGarris Joel Trustee · Los Angeles, CABuilt 2022 · S/N VSWX1270013N24PVMorris Douglas K · Huntsville, ALBuilt 2005 · S/N 64/13N24XDSummitt Air Corp · Wilmington, DEBuilt 2016 · S/N 703 VSW 912
Back to AD 2002-16-07