Skip to content

Registered aircraft · 1,085

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.

N301ATAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2022 · S/N 9213 N301BFEclipse One LLC · Lindon, UTBuilt 2016 · S/N 8245 N301CHCoastal Helicopters Inc · Juneau, AKBuilt 2014 · S/N 7942 N302CHCoastal Helicopters Inc · Juneau, AKBuilt 2016 · S/N 8198 N302SCUsaircraft Inc · Newark, DEBuilt 2002 · S/N 3564 N302TPCity Of Tulsa · Tulsa, OKBuilt 2019 · S/N 8617 N304MPMiami-Dade Sheriff'S Office · Doral, FLBuilt 2011 · S/N 7153 N305MPMiami-Dade Sheriff'S Office · Doral, FLBuilt 2009 · S/N 4759 N306LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7116 N306MPMiami-Dade Sheriffs Office · Doral, FLBuilt 2024 · S/N 9526 N307MPMiami-Dade Sheriffs Office · Doral, FLBuilt 2024 · S/N 9531 N308ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 7619 N308MPMiami-Dade Sheriffs Office · Doral, FLBuilt 2024 · S/N 9574 N309MPMiami-Dade Sheriffs Office · Doral, FLBuilt 2025 · S/N 9597 N30EZHover Air LLC · Anchorage, AKFirst renewal noticeBuilt 2011 · S/N 7285 N30NTCity Of Ontario · Ontario, CABuilt 2020 · S/N 8798 N30RTBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 760511 N310SWWings Air Helicopters LLC · West Harrison, NYBuilt 2014 · S/N 7764 N311WGPentair LLC · Palmetto, FLBuilt 1996 · S/N 760457 N312SDHarris County Sheriffs Office · Spring, TXBuilt 2006 · S/N 4101 N317AMAir Methods LLC · Greenwood Village, COBuilt 2002 · S/N 3506 N318MGNs Air Leasing LLC · Wilmington, DEBuilt 2012 · S/N 7473 N319SPAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21512 N31BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2011 · S/N 7269 N322AHSuperior Helicopter Services LLC · Indianapolis, INBuilt 2016 · S/N 8241 N322GMAdrenaline Rush LLC · Missoula, MTBuilt 2015 · S/N 8159 N322VDepartment Of Homeland Security · Washington, DCBuilt 2019 · S/N 8719 N323CHHelinet Aviation Services LLC · Van Nuys, CABuilt 2005 · S/N 760599 N324BFRiverbend Enterprises Inc · Idaho Falls, IDBuilt 2017 · S/N 8354 N325AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4631 N325WFWfp Aviation Holdings LLC · Midland, TXBuilt 2015 · S/N 8168 N327CHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8095 N327VAAir Wolfpack LLC · Grand Rapids, MIBuilt 2007 · S/N 760695 N328CHAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7328 N328HWSky High Leasing LLC · Montrose, COBuilt 2020 · S/N 8739 N328PKOnyx Aviation LLC · Needham, MABuilt 2005 · S/N 760604 N329AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4645 N329TXTexas Department Of Public Safety · Austin, TXBuilt 2009 · S/N 4794 N3320ADepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9224 N332AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4658 N335AMAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2010 · S/N 7040 N336AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4785 N337ACNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8180 N338SDErie County Sheriffs Office · Buffalo, NYBuilt 2025 · S/N 9745 N339AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7267 N339SDErie County Sheriffs Office · Buffalo, NYBuilt 2025 · S/N 9746 N341AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7232 N342RDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8993 N343PHPhi Aviation LLC · Lafayette, LABuilt 2017 · S/N 20120 N344AMFirst Citizens Bank & Trust Company · Morristown, NJBuilt 2011 · S/N 7235

Back to AD 2016-25-13