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.

N599SDPima County Sheriffs Department · Tucson, AZBuilt 2011 · S/N 7258 N5JVAirbus Helicopters Inc · Grand Prairie, TXS/N 10012 N600HDU S Helicopters Inc · Marshville, NCBuilt 2001 · S/N 3496 N600RSHella Fun 1 LLC · Belle Isle, FLS/N 7399 N601TATrans Aero LLC · Cheyenne, WYBuilt 2009 · S/N 4876 N603CMSoutheast Helicopters LLC · Miami, FLBuilt 1991 · S/N 2491 N604SPAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9868 N6080RTemsco Helicopters Inc · Ketchikan, AKBuilt 1992 · S/N 2685 N608TTemsco Helicopters Inc · Ketchikan, AKBuilt 1998 · S/N 3151 N6094ETemsco Helicopters Inc · Ketchikan, AKBuilt 1994 · S/N 2750 N6094UTemsco Helicopters Inc · Ketchikan, AKBuilt 1994 · S/N 2751 N609TXCopters In Agriculture Llp · Sonora, TXBuilt 2009 · S/N 4776 N60NTCity Of Ontario · Ontario, CABuilt 2017 · S/N 8466 N60TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4488 N610JSListo Air LLC · San Antonio, TXBuilt 2024 · S/N 9583 N610SFReach Air Medical Services LLC · Mcclellan, CABuilt 2011 · S/N 7278 N611TCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1988 · S/N 2123 N612RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 8615 N613CMEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1632 N613RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8920 N613TCT A F Y Consulting · Bristow, VABuilt 2012 · S/N 7522 N614HHSky High Leasing LLC · Montrose, COBuilt 2016 · S/N 8305 N614RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8873 N614SDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1534 N614TCTafy Consulting · Bristow, VABuilt 2012 · S/N 7479 N617CDOklahoma II LLC · Sandy, UTBuilt 2012 · S/N 7540 N617GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4676 N617TVUS Helicopters Inc · Marshville, NCS/N 1725 N618MEMountain Air Helicopters Inc · Dover, DEBuilt 2011 · S/N 7127 N619LHYukon Helicopters Inc · Bethel, AKBuilt 1980 · S/N 1263 N61CVState Of Montana Dept Of Fish Wildlife & Parks · Helena, MTBuilt 2007 · S/N 4367 N61HLTiny Bubbles Aviation Inc · Pacoima, CAS/N 2298 N61RKDylans Rv Center LLC · Sewell, NJBuilt 1998 · S/N 3145 N61RXReach Air Medical Services LLC · Mcclellan, CABuilt 2016 · S/N 8262 N61WLCorpat Inc · Missoula, MTBuilt 2013 · S/N 7752 N6211Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8972 N621FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9127 N6227Austin Police Dept · Pflugerville, TXBuilt 2013 · S/N 7544 N622FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9136 N623FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9235 N623PDCoastal Helicopters LLC · La Vern, CABuilt 2014 · S/N 7894 N624ADEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5656 N624FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9291 N624KSAerial Coalition Surveillance LLC · Winnie, TXBuilt 1989 · S/N 2183 N624TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5459 N625CLMansfield Heliflight Inc · Milton, VTS/N 5545 N625FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9365 N627TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5460 N629AMAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3941 N62ARBird Dog Aircraft LLC · Billings, MTBuilt 2006 · S/N 4175

Back to AD 2015-17-01 R1