Skip to content

AD 2015-17-01 R1

Registered aircraft · 954

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

N857MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7615 N858TTBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 9312 N859MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7685 N860MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7729 N861MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7755 N862MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7771 N863MBReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7814 N864MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7820 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 N868MCLee County Mosquitto Control District · Lehigh Acres, FLBuilt 2018 · S/N 8448 N869MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2025 · S/N 9762 N86LJPc Sky Rotor LLC · Park City, UTBuilt 2021 · S/N 9126 N872SHAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2903 N873SHAris Aviation Group LLC · Boulder City, NVBuilt 1987 · S/N 2060 N877XLRogers Helicopters Inc · Fresno, CABuilt 1999 · S/N 3194 N878XLRogers Helicopters Inc · Clovis, CABuilt 2014 · S/N 7791 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 N881GTReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7983 N881SDCity Of San Diego · San Diego, CABuilt 2019 · S/N 8778 N882GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 7992 N882SDCity Of San Diego · San Diego, CABuilt 2024 · S/N 9553 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 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 N887LHHp Aviation Inc · Oldsmar, FLS/N 5622 N887TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 8073 N888HVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 2386 N888TVU S Helicopters Inc · Marshville, NCBuilt 1978 · S/N 2007 N889AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4959 N889GTGuardian Flight LLC · South Jordan, UTBuilt 2015 · S/N 8011 N893NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8881 N895BCBrevard County Board Of County Commissioners · Titusville, FLBuilt 2013 · S/N 7554 N898JFState Of Montana · Helena, MTBuilt 2007 · S/N 4120 N8DTDt Equipment Leasing LLC · Ten Sleep, WYBuilt 2024 · S/N 9489 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 N903PAirbus Helicopters Inc · Grand Prairie, TXS/N 9892 N904CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8735 N907AMAris Aviation Group LLC · Henderson, NVBuilt 1987 · S/N 2009 N907KDGci Communication Corp · Anchorage, AKBuilt 2024 · S/N 9680 N909KPRiccochet LLC · Okeechobee, FLS/N 1472

Back to AD 2015-17-01 R1