Registered aircraft · 555

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

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-26') 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-26') ORDER BY n_number

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-26')
    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-26')
  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.

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-26')
  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-26')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1018GSale Reported · Scandia, KSSale reported, canceledBuilt 1996 · S/N 03960691 N102TGAvocation Aviation LLC · Findlay, OHS/N CAK04171S N104AJPosav Holdings LLC · Zephyrhills, FLBuilt 2025 · S/N G-1015 N104YRichter-Sand Robert J · Albuquerque, NMBuilt 2017 · S/N KA11316217 N107ERAguila Rosario Jimmy A · Carolina, PRBuilt 2005 · S/N SKR0501558 N107HJLott John R · Andersonville, GABuilt 2015 · S/N ASC-201 N1080Skram Airlines LLC · Wurtsboro, NYBuilt 2013 · S/N 1LK579C N10ZGReeves Air Glide LLC · Moriarty, NMBuilt 2009 · S/N 300 V 912 N111FACharrier Michael J · Hessmer, LAS/N 6000 N112ETTrue Eddie M · Yelm, WABuilt 2007 · S/N CAI02771S N112GSale Reported · SigmaringenSale reportedBuilt 2000 · S/N 37 N113RSBlades Over Me LLC · Vero Beach, FLBuilt 2020 · S/N 071 N115KBFly Away Inc · Lackawanna, NYBuilt 2014 · S/N 1LK588C N11SKStemme N11sk LLC · Missoula, MTBuilt 2019 · S/N 12-030 N120STStemme USA Inc · West Columbia, SCBuilt 2026 · S/N 12-062 N120TLHarrison Richard R · Sacramento, CABuilt 2020 · S/N 75-10869 N1213HBoyle Steven J · Largo, FLBuilt 2016 · S/N 185 N121WHQualitair LLC Trustee · MichelstadtBuilt 2014 · S/N JA377-05-14 N1227ZFisichella David C · Falmouth, MABuilt 2024 · S/N A017 N123TNMontana Retirement Center LLC · Kalispell, MTBuilt 2010 · S/N 006 N1248Johnstone Terry D · Scottsdale, AZBuilt 2025 · S/N KA22106544 N124AFinck Charles F · Liberty Lake, WABuilt 2008 · S/N 1MK 442 C N124FAFirst Airborne LLC · Cocoa, FLBuilt 2015 · S/N MG11-002 N124WLarson Bruce W · Urbana, OHBuilt 2024 · S/N JA428-12-14 N129DCMoonbeam Management LLC · Longwood, FLBuilt 2014 · S/N 1LK574C N129GFFrick Gary A Trustee · Marion, INS/N 126 N12AYYerly Alan K · Valrico, FLBuilt 2009 · S/N A54A N12RTRegistration Pending · Duncan, OKRegistration pendingBuilt 2020 · S/N 1966 N130PSSpackman E Paul · Casper, WYBuilt 2012 · S/N 1250D N133RDGodfrey Kirk P · Cameron Park, CABuilt 2007 · S/N 1DK396C N1345GRegistered aircraftBuilt 2023 · S/N 120310 N134ABSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2002 · S/N PFA 247-13879 N136RTJc/Rc Ventures LLC · Key West, FLS/N 1859 N1386YHannigan Robert V · Gifford, WABuilt 2014 · S/N JA 269-07-12 N139SESahni Irvin K · Seguin, TXBuilt 2004 · S/N 9600 N140VTDetert Bradley · Valparaiso, INBuilt 2014 · S/N 11-140 N143AATorres Vincent Jimenez · Auburndale, FLBuilt 1996 · S/N 10183 N1461FSirmon James A · Daphne, ALBuilt 2020 · S/N 1461 N146UAFoale Aerospace Inc · Houston, TXBuilt 2008 · S/N 102/13 N147DKSpecialty Aerospace LLC · Grand Rapids, MIBuilt 2013 · S/N 1LK568C N14EPBatterman Eric P · Princeton, NJBuilt 2009 · S/N 1DK399C N151SGGurevich Alan · Seattle, WABuilt 2021 · S/N 12-041 N152SGSuedla Holding LLC · Wilmington, DEBuilt 2022 · S/N 12-045 N152TUCampbell Steven G · Newport Beach, CABuilt 2016 · S/N 052 N154RMurphys Auto Gyro Sales LLC · Dade City, FLBuilt 2020 · S/N 0044 N155MLawton John Mann · Whitwell, TNBuilt 2018 · S/N 53418 N15629Williams Donald B · Wingate, NCBuilt 1994 · S/N 0693111 N1564Stick & Rudder LLC · London, KYBuilt 2015 · S/N 160/2015 N158MBKropelin Barry R · Waxhaw, NCBuilt 2020 · S/N 08175451014 N1672LPike Phillip M · Saint Petersburg, FLBuilt 2000 · S/N 7617

Back to AD 2002-16-26