Skip to content

Registered aircraft · 1,086

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

N858HWMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7404 N858MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4503 N858TTBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 9312 N859HWMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7419 N859MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7685 N85LFLf Transportation LLC · New York, NYBuilt 2026 · S/N 21498 N85SKEc 130 LLC · Sterling, VABuilt 2012 · S/N 7388 N860MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7729 N861ALArrow Aviation Company LLC · Broussard, LABuilt 2002 · S/N 760529 N861HWMed-Trans Corp · Denton, TXBuilt 2014 · S/N 7908 N861LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8804 N861MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7755 N862LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8793 N862MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7771 N862MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4545 N863LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8789 N863MBReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7814 N863MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4570 N864MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7820 N864MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4616 N865ALArrow Aviation Company LLC · Broussard, LABuilt 2004 · S/N 760564 N866ALMar Aviation LLC · Tulsa, OKBuilt 2004 · S/N 760562 N866MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7826 N866MCLee County Mosquito Control Destrict · Lehigh Acres, FLBuilt 2017 · S/N 8436 N867MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8443 N867MHMustang Leasing LLC · Henderson, NVBuilt 2009 · S/N 4770 N868ALArrow Aviation Company LLC · Broussard, LABuilt 2004 · S/N 760580 N868MCLee County Mosquitto Control District · Lehigh Acres, FLBuilt 2018 · S/N 8448 N868MHMustang Leasing LLC · Henderson, NVBuilt 2009 · S/N 4797 N869MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2025 · S/N 9762 N86LJPc Sky Rotor LLC · Park City, UTBuilt 2021 · S/N 9126 N872MHMustang Leasing LLC · Henderson, NVBuilt 2012 · S/N 7355 N873MHMustang Leasing LLC · Henderson, NVBuilt 2013 · S/N 7532 N875MHMustang Leasing LLC · Henderson, NVBuilt 2013 · S/N 7592 N876MHMustang Leasing LLC · Henderson, NVBuilt 2013 · S/N 7621 N877MHMustang Leasing LLC · Henderson, NVBuilt 2013 · S/N 7637 N878MHMustang Leasing LLC · Henderson, NVBuilt 2013 · S/N 7779 N878XLRogers Helicopters Inc · Clovis, CABuilt 2014 · S/N 7791 N879MHMustang Leasing LLC · Henderson, NVBuilt 2013 · S/N 7805 N87GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8708 N87MYEast Baton Rouge Parish Mosquito · Baton Rouge, LABuilt 2024 · S/N 9422 N880GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7940 N880MHMustang Leasing LLC · Henderson, NVBuilt 2014 · S/N 7852 N881GTReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7983 N881MHMustang Leasing LLC · Henderson, NVBuilt 2014 · S/N 7898 N881SDCity Of San Diego · San Diego, CABuilt 2019 · S/N 8778 N882GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 7992 N882MHMustang Leasing LLC · Henderson, NVBuilt 2014 · S/N 7913 N882SDCity Of San Diego · San Diego, CABuilt 2024 · S/N 9553 N883ALBristow US LLC · New Iberia, LABuilt 2007 · S/N 760677

Back to AD 2016-25-13