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

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

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.

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

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.

N129RRSteadfast Entities LLC · Philadelphia, PABuilt 2022 · S/N VSWX121A0127 N12AYYerly Alan K · Valrico, FLBuilt 2009 · S/N A54A N12CEChazoo Air Inc · Miami, FLBuilt 2004 · S/N CP001 N12RTRegistration Pending · Duncan, OKRegistration pendingBuilt 2020 · S/N 1966 N130PSSpackman E Paul · Casper, WYBuilt 2012 · S/N 1250D N130TVVincent Terry K · Greenville, KYBuilt 2009 · S/N KCU 130 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 N139CTGrandinetti Robert L · Fayetteville, NYBuilt 2006 · S/N 06-07-02 N139SESahni Irvin K · Seguin, TXBuilt 2004 · S/N 9600 N140VTDetert Bradley · Valparaiso, INBuilt 2014 · S/N 11-140 N141YRowland Richard · Hondo, TXFirst renewal noticeBuilt 2007 · S/N 04061736 N143AATorres Vincent Jimenez · Auburndale, FLBuilt 1996 · S/N 10183 N1447WRegistered aircraftBuilt 1993 · S/N 1618 N1461FSirmon James A · Daphne, ALBuilt 2020 · S/N 1461 N1469HSinnott-Simonis Lyle · Girdwood, AKFirst renewal noticeBuilt 2014 · S/N 007 N146CDStevens Mike · Duluth, MNS/N 014-068 N146EPLenz Christian J · Allen, TXBuilt 2023 · S/N VSWX121A0146 N146UAFoale Aerospace Inc · Houston, TXBuilt 2008 · S/N 102/13 N147DKSpecialty Aerospace LLC · Grand Rapids, MIBuilt 2013 · S/N 1LK568C N148SRTansky Stanley S · Logan, OHBuilt 2010 · S/N IDK395C N14EPBatterman Eric P · Princeton, NJBuilt 2009 · S/N 1DK399C N151SGGurevich Alan · Seattle, WABuilt 2021 · S/N 12-041 N152GHatfield Keith A · Dallas, TXBuilt 2012 · S/N 000588 N152SGSuedla Holding LLC · Wilmington, DEBuilt 2022 · S/N 12-045 N152TUCampbell Steven G · Newport Beach, CABuilt 2016 · S/N 052 N152WPCook Christopher M · Twin Falls, IDS/N 04-285 N153WPFlamingo Aviation LLC · Bend, ORBuilt 2006 · S/N 04-286 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 N156TXDucote Kendall J · Prairieville, LABuilt 2008 · S/N PC120791P504 N156WSDryden Everett R · Wolcott, VTBuilt 1999 · S/N 1190-0399-7-W993 N158MBKropelin Barry R · Waxhaw, NCBuilt 2020 · S/N 08175451014 N161RNWaterwings Seaplanes LLC · Hoover, ALBuilt 2005 · S/N AC061 N164XStetson Jeffry W · East Lansing, MIFirst renewal noticeBuilt 2005 · S/N 200164 N166KWalker Troy L · Greenville, ILBuilt 2008 · S/N 0707468 N1672LPike Phillip M · Saint Petersburg, FLFirst renewal noticeBuilt 2000 · S/N 7617 N167TUHawkins Flight Academy LLC · Shelbyville, TNS/N 167/US N1682WDavis Chad A · Luana, IABuilt 2004 · S/N 1100088 N1688BChen Chris · Monrovia, CABuilt 2013 · S/N V00123 N168MBNemec David M · Helendale, CABuilt 2007 · S/N 125-07-02 N16BAOwen Aviation Co LLC · Meridian, MSBuilt 2020 · S/N 16202693 N16BMWilson Joshua A · Mckinney, TXBuilt 2022 · S/N PM007 N170TUMichigan Department Of Natural Resources · Roscommon, MIBuilt 2016 · S/N 170/US N172LMBristol Todd J · Mesa, AZBuilt 2009 · S/N F-09-08-05

Back to AD 2002-16-07