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.

N883GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8001 N883SDCity Of San Diego · San Diego, CABuilt 2024 · S/N 9573 N884GTReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 8004 N884MHMustang Leasing LLC · Henderson, NVBuilt 2014 · S/N 7979 N884SDCity Of San Diego Police Air Support Unit · San Diego, CABuilt 2025 · S/N 9626 N886GTGuardian Flight LLC · South Jordan, UTBuilt 2015 · S/N 8091 N886MHMustang Leasing LLC · Henderson, NVBuilt 2015 · S/N 8060 N889AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4959 N889GTGuardian Flight LLC · South Jordan, UTBuilt 2015 · S/N 8011 N891BGGm Leasing Co LLC · Broussard, LABuilt 2007 · S/N 760679 N891GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8136 N892GTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 8151 N893BGBristow U S LLC · New Iberia, LABuilt 2009 · S/N 760804 N893GTMed-Trans Corporation · Denton, TXBuilt 2015 · S/N 8155 N893NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8881 N893PARainier Heli International Inc · Kirkland, WABuilt 2009 · S/N 4679 N894GTAir Evac Ems Inc · O'Fallon, MOBuilt 2015 · S/N 8185 N894PAJuliet Inc · Kirkland, WABuilt 2009 · S/N 4687 N8959SJuliet Inc · Kirkland, WABuilt 2007 · S/N 4232 N895BCBrevard County Board Of County Commissioners · Titusville, FLBuilt 2013 · S/N 7554 N896BGBristow U.S. LLC · New Iberia, LAS/N 760777 N897SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 8213 N898JFState Of Montana · Helena, MTBuilt 2007 · S/N 4120 N8DTDt Equipment Leasing LLC · Ten Sleep, WYBuilt 2024 · S/N 9489 N8EURegistered aircraftBuilt 2025 · S/N 21339 N8KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 20353 N901CFRegional Emergency Medical Services Authority · Reno, NVBuilt 2006 · S/N 4160 N901JBMartin County Sheriffs Office · Stuart, FLBuilt 2025 · S/N 9754 N901TPCity Of Tulsa · Tulsa, OKBuilt 2023 · S/N 9435 N902CFRegional Emergency Medical Services Authority · Reno, NVBuilt 2024 · S/N 9438 N903CFRegional Emergency Medical Svcs Authority (Remsa) · Reno, NVBuilt 2023 · S/N 9381 N904CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8735 N905RDBristow LLC · Lake Charles, LABuilt 2006 · S/N 760610 N907KDGci Communication Corp · Anchorage, AKBuilt 2024 · S/N 9680 N907MTFirst-Citizens Bank & Trust Co · Morristown, NJBuilt 2023 · S/N 9539 N908PSTrevor Corp DBA · Grayslake, ILBuilt 2006 · S/N 4177 N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807 N90ZXRegistered aircraftBuilt 2018 · S/N 8554 N910LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7856 N910UAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 3470 N91122Teton County Wyoming · Jackson, WYBuilt 2023 · S/N 9326 N911AAState Of Alaska · Anchorage, AKBuilt 2013 · S/N 7536 N911DCMayor And City Council Of Washington Dc · Washington, DCBuilt 2023 · S/N 9452 N911DGHillsborough County Sheriffs Office · Tampa, FLBuilt 2020 · S/N 8859 N911DSCounty Of Hawaii · Hilo, HIBuilt 2022 · S/N 9244 N911EHEnloe Hospital · Chico, CABuilt 2023 · S/N 9498 N911MQParkhursts Fly LLC · Newark, DEBuilt 2021 · S/N 9153 N911NQCharlotte County Sheriffs Office · Punta Gorda, FLBuilt 2011 · S/N 7299 N911NTState Of Alaska · Anchorage, AKBuilt 2013 · S/N 7665 N911RPCity Of Riverside · Riverside, CABuilt 2022 · S/N 9264

Back to AD 2016-25-13