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.

N3937ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4796 N3938ADepartment Of Homeland Security · Washington, DCS/N 4804 N3939ADept Of Homeland Security Customs & Border · Washington, DCBuilt 2009 · S/N 4806 N393NSNorth Star Trekking LLC · Juneau, AKBuilt 2009 · S/N 4762 N393PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7669 N3940ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4815 N3944ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4818 N3946ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4706 N3947ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4905 N3949ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4952 N394NSNorthstar Trekking · Juneau, AKBuilt 1979 · S/N 1066 N394PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7694 N3951AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 4993 N3953AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7004 N3972AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7082 N397NSNorthstar Trekking LLC · Juneau, AKBuilt 2012 · S/N 7466 N397PPhi Health LLC · Tempe, AZBuilt 2014 · S/N 7795 N3980AUS Department Of Homeland Security · Washington, DCS/N 7064 N3983AUS Department Of Homeland Security · Washington, DCBuilt 2011 · S/N 7101 N3990AUS Department Of Homeland Security · Washington, DCS/N 7107 N399LGAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8086 N39EWTuckamore Aviation Corp · Hudson, MABuilt 2002 · S/N 3570 N401RMRegional Air Medical Services Inc. · Jasper, ALBuilt 2004 · S/N 3837 N4022DTemsco Helicopters Inc · Ketchikan, AKBuilt 1995 · S/N 2891 N402JCJefferson County Sheriffs Office · Birmingham, ALBuilt 2006 · S/N 4184 N4035WDepartment Of Homeland Security · Washington, DCBuilt 1996 · S/N 2912 N403AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3281 N4048LU S Dept Of Homeland Security · Washington, DCBuilt 1997 · S/N 3020 N4055LU S Dept Of Homeland Security · Washington, DCBuilt 1996 · S/N 2916 N40584Bristow LLC · Lake Charles, LABuilt 1998 · S/N 2924 N405AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3286 N405AMAris Aviation Group LLC · Henderson, NVBuilt 1995 · S/N 2833 N405TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4476 N4061GBristow LLC · Lake Charles, LABuilt 1997 · S/N 3051 N4068WU S Dept Of Homeland Security · Washington, DCBuilt 1996 · S/N 2934 N406AMAris Aviation Group LLC · Boulder City, NVBuilt 1990 · S/N 2391 N4074EAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1996 · S/N 2950 N4075SD&B Global Ventures LLC · Key West, FLBuilt 1997 · S/N 3043 N40AKH125 Aviation LLC · Dover, DEBuilt 2021 · S/N 9116 N410CKCharm City Aviation LLC · Baltimore, MDBuilt 2004 · S/N 3793 N411LHApex Aeronautical · San Antonio, TXBuilt 2009 · S/N 4667 N411MBVertical Corp · Kalispell, MTBuilt 2000 · S/N 3309 N413EAMadprop LLC · Kalispell, MTBuilt 2022 · S/N 9182 N413JMHillsborough County Sheriffs Office · Tampa, FLBuilt 2024 · S/N 9537 N413LPCamape Se · Las Piedras, PRBuilt 1999 · S/N 3228 N418MDMountain Air Helicopters Inc · Dover, DEBuilt 2004 · S/N 3848 N418TYAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4180 N4204Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4204 N420JABristow LLC · Lake Charles, LABuilt 2007 · S/N 4212 N4282Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4282

Back to AD 2015-17-01 R1