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.

N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687 N499DAWtj Capital Holdings III LLC · Vero Beach, FLBuilt 2022 · S/N 9285 N49AHA7p Trust Company Inc Trustee · Cheyenne, WYBuilt 2023 · S/N 21194 N4PAPylon Aviation Services LLC · Chandler, AZBuilt 2005 · S/N 3920 N500KVPortland General Electric Co · Portland, ORBuilt 2008 · S/N 4638 N502GRAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 2022 · S/N 9334 N502LMLouisville/Jefferson County Metro Government · Louisville, KYBuilt 2024 · S/N 9510 N506LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4973 N507AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4711 N508AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4682 N509DRMaverick Air LLC · Deer Park, WABuilt 2014 · S/N 7887 N50NTCity On Ontario · Upland, CABuilt 2023 · S/N 9433 N5125N5125 LLC · North Las Vegas, NVBuilt 2017 · S/N 8381 N514FWOffice Of Aviation Services · Boise, IDBuilt 2023 · S/N 9339 N517LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9636 N517MCPasco County Mosquito Control District · Odessa, FLBuilt 2020 · S/N 8805 N518MCPasco County Mosquito Control District · Odessa, FLBuilt 2020 · S/N 8814 N518MFCoastal Helicopters Inc · Juneau, AKBuilt 2012 · S/N 7436 N519FFSky High Leasing LLC · Montrose, COBuilt 2014 · S/N 7924 N520AHBering Air Inc · Nome, AKBuilt 2018 · S/N 8607 N521Airbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9942 N523RHSkyyhigh LLC · South Salem, NYBuilt 2017 · S/N 8439 N523SEVfi Kr Spe I LLC · Salt Lake City, UTBuilt 2014 · S/N 7965 N529SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 7564 N530ECEl Dorado County Sheriffs Office · Placerville, CABuilt 2013 · S/N 7708 N530HBas Part Sales LLC · Greeley, COBuilt 2008 · S/N 4553 N531SPAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21508 N533AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4620 N534PDepartment Of Homeland Security · Washington, DCBuilt 2018 · S/N 8499 N534PDFresno Police Department · Fresno, CABuilt 2025 · S/N 9698 N538FSBayou Skys LLC · Wilmington, DEBuilt 2008 · S/N 4478 N539SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 8784 N540SFOsf Aviation LLC · Peoria, ILBuilt 2023 · S/N 21230 N54178Air Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4178 N541WERegistered aircraftBuilt 2025 · S/N 21413 N54315Discovery Helicopters LLC · Las Vegas, NVS/N 4315 N544AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4206 N544ASApexheli Oregon Inc · Florence, ORBuilt 2001 · S/N 3367 N545HFHaynes Aviation LLC · Wetumpka, ALBuilt 2006 · S/N 4123 N547WMBristow LLC · Lake Charles, LABuilt 2008 · S/N 760722 N54DERegistered aircraftBuilt 2025 · S/N 21368 N54MNWestern Sky Aviation LLC · Scottsdale, AZBuilt 2013 · S/N 7583 N551AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4311 N555VTArlo Air LLC · Columbus, OHBuilt 2010 · S/N 4988 N556SDHarris County Sheriffs Office · Houston, TXBuilt 2011 · S/N 7086 N556TXTexas Dept Of Public Safety · Austin, TXBuilt 2025 · S/N 9797 N559SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 8648 N55GJCfa Holdings Inc · Knoxville, TNBuilt 2003 · S/N 3745 N562AHRegistered aircraftBuilt 2019 · S/N 8696 N568AENs Air Leasing LLC · Wilmington, DEBuilt 2013 · S/N 7647

Back to AD 2016-25-13