OpenAirDocs.org
AD 2016-25-13

Registered aircraft · 1,084

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.

N155RRCas LLC · Longboat Key, FLBuilt 1996 · S/N 760464N155TDAjd Aviation LLC · Dorado, PRS/N 6664N155UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6934N156BCEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2002 · S/N 3614N156GCXebec LLC · Kirkland, WABuilt 2011 · S/N 7296N156UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6935N157AEBoeing Company · Mesa, AZBuilt 2011 · S/N 7171N157UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6933N15AHSan Francisco Bay Heli LLC · San Francisco, CABuilt 2022 · S/N 9295N1603MCity Of San Antonio Texas · San Antonio, TXBuilt 2018 · S/N 8563N162GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9926N162TMSaberair LLC · Englewood, COBuilt 2019 · S/N 8654N165GRMed-Trans Corp · Denton, TXBuilt 2026 · S/N 9925N168BHBhi Holdings #1 LLC · Ontario, ORBuilt 2018 · S/N 8613N172AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3839N173BHBhh Leasing #4 LLC · Pensacola, FLBuilt 2009 · S/N 4614N174AHAres Air LLC · Phoenix, AZBuilt 2022 · S/N 9121N175SCSeminole County Sheriffs Office · Sanford, FLBuilt 2017 · S/N 8430N176AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2007 · S/N 760665N176FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2007 · S/N 760646N176MTDr Heli Acquistion LLC · Princeton, NJBuilt 2004 · S/N 6677N176SCSeminole County Sheriffs Office · Sanford, FLBuilt 2024 · S/N 9495N178MTTribeca Heli LLC · Princeton, NJBuilt 1998 · S/N 6527N180QDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8815N181PLAlpine Air Alaska LLC · Girdwood, AKBuilt 2014 · S/N 7812N183SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2017 · S/N 8376N184RDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9158N185SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2016 · S/N 8125N186AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3872N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846N188EULashinski Robert D Trustee · Sebastopol, CABuilt 2011 · S/N 7188N190GRReach Air Medical Services LLC · Lewisville, TXBuilt 2026 · S/N 9909N191NRMaryland Natural Resources Police · Stevensville, MDBuilt 2023 · S/N 9382N191TXTexas Dept Of Public Safety · Austin, TXBuilt 2010 · S/N 4841N192ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7184N194AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3338N1958MMjb Investments LLC · Bellevue, WABuilt 2015 · S/N 8130N195GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9974N1964LDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9179N1977GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9192N1984SMidcap Equipment Finance LLC · Wilton, CTBuilt 2022 · S/N 21138N198AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3371N19AHA7p Trust Company Inc Trustee · Cheyenne, WYBuilt 2025 · S/N 21297N19NLWabel Brad · Boerne, TXBuilt 2018 · S/N 8593N1CRComanche Maverick Air LLC · Houston, TXBuilt 2016 · S/N 8165N1MZA Star 350 LLC · Henderson, NVS/N 7300N203ZDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8811N204WBAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9965N208SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7644N209LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4960
Back to AD 2016-25-13