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

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

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.

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

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.

N430GRReach Air Medical Services LLC · Mcclellan, CABuilt 2025 · S/N 9735 N430SPState Of New York · Latham, NYBuilt 2025 · S/N 21314 N431GRReach Air Medical Services LLC · Santa Rosa, CABuilt 2025 · S/N 9759 N434UTFirst Citizens Bank & Trust Co · Morristown, NJBuilt 2023 · S/N 9525 N435LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 21232 N435UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9627 N437AHRoberts Aircraft LLC · Cheyenne, WYBuilt 2017 · S/N 8419 N438MUMarshall University · Huntington, WVBuilt 2012 · S/N 7240 N43SDPinellas County Sheriffs Office · Largo, FLBuilt 2021 · S/N 9149 N43WLCorpat Inc · Missoula, MTBuilt 2025 · S/N 21383 N440RMRegional Air Medical Services Inc · Jasper, ALBuilt 2010 · S/N 7017 N444YUnion Airspeed LLC · Cincinnati, OHBuilt 2008 · S/N 6827 N447WAWallasch Aviation LLC · Alpine, WYBuilt 2023 · S/N 9447 N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497 N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615 N4514RArrow Aviation Company LLC · Broussard, LAS/N 760669 N451FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9250 N452FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9293 N453FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2023 · S/N 9317 N454PDCounty Of Suffolk Police Department · Ronkonkoma, NYBuilt 2026 · S/N 21429 N454WHGm Leasing Company LLC · Broussard, LABuilt 2010 · S/N 760802 N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932 N456AEEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 3492 N45KVRegistered aircraftBuilt 2025 · S/N 21358 N45RSSpiegel Aviation LLC · North Palm Beach, FLBuilt 2023 · S/N 9376 N462MHMemorial Hermann Health System · Houston, TXBuilt 2025 · S/N 21374 N464MHMemorial Hermann Health System · Houston, TXBuilt 2024 · S/N 21296 N464RMRegional Air Medical Services Inc · Jasper, ALBuilt 2005 · S/N 3962 N466MHMemorial Hermann Health System · Houston, TXBuilt 2025 · S/N 21440 N467MHMemorial Hermann Health System · Houston, TXBuilt 2024 · S/N 21298 N468PFFranklin Mountain Assets II LLC · El Paso, TXBuilt 2023 · S/N 9482 N470RGG350 Leasing LLC · Portland, ORBuilt 2017 · S/N 8469 N472LALapd Air Support Division · Los Angeles, CABuilt 2018 · S/N 8472 N479CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8820 N479DVDbd Properties LLC · Grand Rapids, MIBuilt 2015 · S/N 8079 N47CKRegistered aircraftBuilt 2024 · S/N 21267 N47WHInternational Air Services Inc Trustee · Carson City, NVBuilt 2003 · S/N 3653 N483LWU S Bank N A · Marshall, MNBuilt 2026 · S/N 21483 N483MAUS Bank Na · Marshall, MNBuilt 2023 · S/N 21202 N483WCU S Bank Na · Marshall, MNBuilt 2022 · S/N 21132 N483WMUS Bank Na · Marshall, MNBuilt 2023 · S/N 21206 N484FAFreedom Aviation LLC · Helena, MTBuilt 2008 · S/N 4499 N487HBCounty Of Butte · Oroville, CABuilt 2020 · S/N 8886 N490HAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4539 N491LGAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8553 N493LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8764 N493WAVertol Systems Co Inc · Destin, FLFirst renewal noticeBuilt 2012 · S/N 7534 N494LGManufacturers And Traders Trust Company · Bridgeport, CTBuilt 2019 · S/N 8750 N495RLSugar Pine Aviation LLC · Merlin, ORBuilt 2005 · S/N 760595 N496LGAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8582

Back to AD 2016-25-13