Skip to content

AD 2015-17-01 R1

Registered aircraft · 953

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.

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 N52ZXRichard Schuman LLC · Kailua, HIS/N 5515 N530ECEl Dorado County Sheriffs Office · Placerville, CABuilt 2013 · S/N 7708 N530HBas Part Sales LLC · Greeley, COBuilt 2008 · S/N 4553 N531BJg Boswell Co · Corcoran, CAS/N 7161 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 N539SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 8784 N540DBMaster Link Corp · Barceloneta, PRBuilt 1999 · S/N 3218 N54178Air Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4178 N54315Discovery Helicopters LLC · Las Vegas, NVS/N 4315 N543MMHappyheight Inc · El Monte, CABuilt 2013 · S/N 7636 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 N547AMTrevor Corp DBA · Grayslake, ILBuilt 2007 · S/N 4332 N547SAShier Aviation Corp DBA · San Diego, CABuilt 1988 · S/N 2124 N54MNWestern Sky Aviation LLC · Scottsdale, AZBuilt 2013 · S/N 7583 N550AEMhoc LLC · Pensacola, FLBuilt 2007 · S/N 5759 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 N557CBChaparral Air Group · Grapevine, TXBuilt 2001 · S/N 3431 N559SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2019 · S/N 8648 N562AHRegistered aircraftBuilt 2019 · S/N 8696 N568AENs Air Leasing LLC · Wilmington, DEBuilt 2013 · S/N 7647 N568AMEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2008 · S/N 4462 N570AETemsco Helicopters Inc · Ketchikan, AKBuilt 2012 · S/N 7489 N573AMIsland Air LLC · Westbury, NYBuilt 2008 · S/N 4487 N574AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4613 N576AMAris Aviation Group LLC · Henderson, NVBuilt 2008 · S/N 4418 N57954Ns Air Leasing LLC · Wilmington, DEBuilt 1979 · S/N 1127 N5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 1836 N582RDCity Of San Antonio · San Antonio, TXBuilt 2024 · S/N 9496 N583SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 7567 N5854ZPuerto Rico Electric Power Authority · Carolina, PRBuilt 2002 · S/N 3505 N5855ZPuerto Rico Electric Power Authority · San Juan, PRBuilt 2001 · S/N 3518 N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736 N589SHCsc Delaware Trust Co Trustee · Wilmington, DES/N 7745 N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733 N594LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9923 N594MCEast Flagler Mosquito Control District · Palm Coast, FLBuilt 2023 · S/N 9405 N596LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9901 N596MSNs Air Leasing LLC · Wilmington, DEBuilt 1988 · S/N 1884 N596WAFleet Unlimited Inc · Pasadena, CABuilt 1990 · S/N 2329 N597LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9885

Back to AD 2015-17-01 R1