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.

N286TAMfga LLC · Smyrna, TNBuilt 2014 · S/N 136/USN287DGGardner David C · Williston, SCS/N 07010935N290JJThompson James W · Bronwood, GABuilt 2007 · S/N 676N291FASafety Management Training LLC · Hamburg, NYBuilt 2024 · S/N A447ULSN292CFWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 1140/USN294CMLag Drywall Inc · Hampton, GABuilt 2019 · S/N 294/USN2979AVannuil Jerry E · Holland, MIBuilt 2001 · S/N 000650N297RHanley Mark S · Bristol, MEBuilt 2006 · S/N 711N298BLAmbient Air Technologies LLC · Fort Collins, COBuilt 2017 · S/N 298/2017N299TANorth Country Aero LLC · Hanover, NHBuilt 2007 · S/N JAESC0108N29FPCaribbean Amphibian LLC · Punta Gorda, FLS/N 07-01-51-572N29STShewmaker Air LLC · Bentonville, ARBuilt 2019 · S/N 12029N29WGClinton Peter C · Cheyenne, WYBuilt 2006 · S/N 1MK296CN300MJSnider Aaron Andrew · Hart, MIBuilt 1999 · S/N AC039N302CAAviation Financial Corp · Torrance, CABuilt 2011 · S/N 070N3035GMason Brooks Aviation LLC · Severn, MDBuilt 2023 · S/N 379N304PBMcgehee Aviation Services LLC · Zephyrhills, FLBuilt 2008 · S/N 006 LSAN304PPArrington Ray · Jackson, MIBuilt 2024 · S/N A448ULSN304USBuiqui Aerospace Corp · Kissimmee, FLBuilt 2024 · S/N 403/USN304WSMaberry Buell G · Pierre, SDS/N 007 LSAN30628Zollinger Rudolph A · Rittman, OHBuilt 1999 · S/N 001N307DNRegistration Pending · Scottsdale, AZRegistration pendingS/N 07SC056N30ALLink Alden · Milton, NYBuilt 2007 · S/N 73735N311DZSawaf Darius · Dallas, TXBuilt 2007 · S/N 243N31311Mcclure Jared B · Claremore, OKBuilt 2007 · S/N D99912SOHK0356N313CMTray Jason R · Juneau, WIBuilt 2017 · S/N T&S J28117SN31408Adams John P · Rosebud, MOBuilt 2006 · S/N A082ULFN3143MSmile Machine LLC · Auburn, WABuilt 2007 · S/N 002N3143SStafford Marlin C · Patterson, GABuilt 2024 · S/N JA697-6-23N314BJClayton Smith · Green River, WYFirst renewal noticeBuilt 2014 · S/N C0111-0271N31718Ohlrich Greg · Mount Dora, FLBuilt 2007 · S/N 0902031N3173PHalberg Bill R · Battle Ground, WABuilt 2005 · S/N HD04130XCN31750Yeats Chris P · Collinsville, OKS/N 001N31788Falcontrust Holdings LLC · Pinecrest, FLBuilt 2007 · S/N UA004N317GWWings Over Texas Holdings LLC · Denton, TXBuilt 2026 · S/N 442/USN31EEJudd Tharon · Orem, UTBuilt 2019 · S/N AC-215N3200VKnight Brent · Moundridge, KSBuilt 2010 · S/N IPP-10-393N321CAGarratt Carol Ann · Moriarty, NMBuilt 2006 · S/N 0504372N321HCLinda Vista Aviation Inc · West Palm Beach, FLBuilt 2015 · S/N 11-143N322PZUsibelli Joseph E · Fairbanks, AKBuilt 2013 · S/N 1LK573CN329PTPilot Training Center LLC · Miami, FLBuilt 2017 · S/N 237/USN330BLCentral Seaplanes LLC · Cleveland, OKBuilt 2022 · S/N 148N330VAN330va LLC · Plymouth, MIBuilt 2022 · S/N 348/USN33223Clayton Randall L · Mapleton, UTBuilt 2003 · S/N A 139 PEGN333VTCanfield Dan · Ephrata, WABuilt 1998 · S/N 11-013N334CTAngel LLC · Missoula, MTBuilt 2006 · S/N 06-07-17N334QHuitema Tom P · Portage, MIBuilt 2020 · S/N 1LK578CN3372Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 1083 SFNM 912 LSAN337SELee Mark J · Arlington, WABuilt 2023 · S/N 120970N339PDWhiteley James N · Reno, NVS/N 1MK437C
Back to AD 2002-16-07