Skip to content

Registered aircraft · 373

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:2014-26-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-26-09') 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:2014-26-09')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-26-09')
  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:2014-26-09')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-26-09')
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.

N100RPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 9450 N1019LRegistered aircraftBuilt 2003 · S/N 9125 N103SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 9129 N104DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9266 N1098LLasai Aviation II LLC · Manassas, VABuilt 2023 · S/N 60098 N111FKFk Air LLC · Miami, FLBuilt 2001 · S/N 9101 N112MYAir Force Fun LLC · Woodbury, NYBuilt 2011 · S/N 9442 N115JSRegistered aircraftBuilt 2015 · S/N 9744 N115MHA7p Trust Co Inc Trustee · Cheyenne, WYBuilt 2011 · S/N 9463 N115TRTasco LLC · New York, NYBuilt 2000 · S/N 9067 N116SFAlten Consulting LLC · Fort Lauderdale, FLBuilt 2015 · S/N 9709 N117TPR&C Xrs Owner LLC · Beverly, MABuilt 2005 · S/N 9175 N118MJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 9253 N11UBRegistered aircraftBuilt 2008 · S/N 9276 N121SALove Wing Venture LLC · Agoura Hills, CABuilt 2001 · S/N 9082 N122BNTrfo LLC · New York, NYS/N 9826 N123EBTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 9167 N1244Leon Global Express LLC · Miami, FLBuilt 2004 · S/N 9151 N124GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 9641 N124STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 9800 N125CHPwcm Charter LLC · Highland Park, ILBuilt 2001 · S/N 9080 N129AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 9381 N141QSRegistered aircraftBuilt 2012 · S/N 9479 N142QSRegistered aircraftBuilt 2012 · S/N 9485 N143MWMusic For The People Inc · Newton, MABuilt 2002 · S/N 9109 N143QSRegistered aircraftBuilt 2012 · S/N 9499 N145QSRegistered aircraftBuilt 2014 · S/N 9598 N146ABBig Brie LLC · Wilmington, DEBuilt 2001 · S/N 9100 N146QSRegistered aircraftBuilt 2014 · S/N 9615 N147QSRegistered aircraftBuilt 2014 · S/N 9632 N148QSRegistered aircraftBuilt 2014 · S/N 9648 N149LPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 9019 N150QSRegistered aircraftBuilt 2014 · S/N 9657 N151QSRegistered aircraftBuilt 2015 · S/N 9730 N152PGAirish LLC · Orchard Lake, MIBuilt 1999 · S/N 9041 N152QSRegistered aircraftBuilt 2016 · S/N 9773 N154QSRegistered aircraftBuilt 2017 · S/N 9804 N155QSRegistered aircraftS/N 9832 N156QSRegistered aircraftBuilt 2018 · S/N 9856 N157QSRegistered aircraftBuilt 2019 · S/N 9870 N158QSRegistered aircraftS/N 60024 N160QSRegistered aircraftBuilt 2012 · S/N 9475 N162QSRegistered aircraftBuilt 2012 · S/N 9484 N163EGC Dot Aviation LLC · Dover, DEBuilt 2000 · S/N 9069 N163QSRegistered aircraftBuilt 2013 · S/N 9557 N164QSRegistered aircraftBuilt 2014 · S/N 9649 N165QSRegistered aircraftBuilt 2015 · S/N 9726 N165VTMansfield Heliflight Inc · Milton, VTBuilt 2012 · S/N 9493 N166QSRegistered aircraftBuilt 2013 · S/N 9545 N167QSRegistered aircraftBuilt 2015 · S/N 9689

Back to AD 2014-26-09