OpenAirDocs.org
AD 2016-25-13

Registered aircraft · 1,086

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

N3937ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4796N3938ADepartment Of Homeland Security · Washington, DCS/N 4804N3939ADept Of Homeland Security Customs & Border · Washington, DCBuilt 2009 · S/N 4806N393PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7669N393PHPhi Aviation LLC · Lafayette, LABuilt 2017 · S/N 20122N3940ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4815N3944ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4818N3946ADepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N 4706N3947ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4905N3949ADepartment Of Homeland Security · Washington, DCBuilt 2010 · S/N 4952N394PPhi Health LLC · Tempe, AZBuilt 2013 · S/N 7694N3951AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 4993N3953AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7004N3972AUS Department Of Homeland Security · Washington, DCBuilt 2010 · S/N 7082N397NSNorthstar Trekking LLC · Juneau, AKBuilt 2012 · S/N 7466N397PPhi Health LLC · Tempe, AZBuilt 2014 · S/N 7795N3983AUS Department Of Homeland Security · Washington, DCBuilt 2011 · S/N 7101N399KKRegistered aircraftBuilt 2003 · S/N 760550N399LGAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8086N39EWTuckamore Aviation Corp · Hudson, MABuilt 2002 · S/N 3570N39HFHeliflite Shares LLC · Kearny, NJBuilt 2011 · S/N 760808N3BUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 21243N3CRIron Blonde LLC · Lewes, DEBuilt 2022 · S/N 21146N3KATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 21268N3WLWell Lived Mt LLC · Kalispell, MTBuilt 2023 · S/N 9505N400AHAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2016 · S/N 8249N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024N401RMRegional Air Medical Services Inc. · Jasper, ALBuilt 2004 · S/N 3837N402JCJefferson County Sheriffs Office · Birmingham, ALBuilt 2006 · S/N 4184N405LAircraft On Ground Solutions LLC DBA · Tanner, ALS/N 21139N406KHWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N 21088N406YCTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 20238N40AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9800N40AKH125 Aviation LLC · Dover, DEBuilt 2021 · S/N 9116N40WHGm Leasing Co LLC · Broussard, LABuilt 2009 · S/N 760756N410WAir Methods LLC · Greenwood Village, COBuilt 2016 · S/N 8240N411LHApex Aeronautical · San Antonio, TXBuilt 2009 · S/N 4667N411MBVertical Corp · Kalispell, MTBuilt 2000 · S/N 3309N412RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 8542N413EAMadprop LLC · Kalispell, MTBuilt 2022 · S/N 9182N413JMHillsborough County Sheriffs Office · Tampa, FLBuilt 2024 · S/N 9537N413RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 8444N413UTMed-Trans Corporation · Denton, TXBuilt 2024 · S/N 9618N414RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8909N415RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 9130N418TYAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4180N41SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2016 · S/N 8300N4204Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4204N425AMFirst-Citizens Bank & Trust Co · Morristown, NJBuilt 2011 · S/N 7264N4282Air Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4282
Back to AD 2016-25-13