Skip to content

AD 2018-01-12 R1

Registered aircraft · 646

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:2018-01-12-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:2018-01-12-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:2018-01-12-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:2018-01-12-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:2018-01-12-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:2018-01-12-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.

N387AK387ak LLC · Anchorage, AKS/N 3730 N389PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7627 N38HXHelicopter Express LLC · Chamblee, GABuilt 2014 · S/N 8006 N391LGAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4323 N391PPhi Health LLC · Tempe, AZBuilt 2024 · S/N 9644 N392HSIkarus Aviation LLC · West Jordan, UTS/N 3252 N392PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7662 N3931ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4697 N3933ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4669 N3934ADepartment Of Homeland Security · Washington, DCS/N 4713 N3935ADepartment Of Homeland Security · Washington, DCS/N 4768 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 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 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 N402JCJefferson County Sheriffs Office · Birmingham, ALBuilt 2006 · S/N 4184 N403AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3281 N405AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3286 N40AKH125 Aviation LLC · Dover, DEBuilt 2021 · S/N 9116 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 N4282Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4282 N437AHRoberts Aircraft LLC · Cheyenne, WYBuilt 2017 · S/N 8419 N438MUMarshall University · Huntington, WVBuilt 2012 · S/N 7240 N43MJl Mark LLC · Missoula, MTS/N 8967 N43SDPinellas County Sheriffs Office · Largo, FLBuilt 2021 · S/N 9149 N43VPRoberts Aircraft LLC · Cheyenne, WYBuilt 2000 · S/N 3272

Back to AD 2018-01-12 R1