Skip to content

Registered aircraft · 1,085

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.

N20AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9714 N2108JDeparment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9200 N210LMAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21469 N2119AArrow Aviation Co LLC · Broussard, LAS/N 760640 N211LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9910 N211LPHeliquest LLC · Greenville, SCBuilt 2015 · S/N 8181 N212HKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 4703 N212KPitch Link LLC · New York, NYBuilt 2010 · S/N 7030 N212LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9919 N213PFLapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8340 N213SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7651 N215GHBase Camp Aviation LLC · Mccall, IDBuilt 1998 · S/N 3147 N216AHBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2024 · S/N 9665 N216SHAir Methods LLC · Greenwood Village, COS/N 7674 N217HPNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3628 N218SHSuperior Helicopter Services LLC · Indianapolis, INBuilt 2018 · S/N 8458 N21FYH125 Aviation LLC · Wailea, HIBuilt 2024 · S/N 9465 N221LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7900 N221MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8680 N221PAFa Aviation Logistics Inc · Houston, TXBuilt 2014 · S/N 7851 N222SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7943 N223DECdv Se Properties LLC · Grand Rapids, MIBuilt 2019 · S/N 8693 N223LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7956 N223MTMed-Trans Corp · Denton, TXBuilt 2019 · S/N 8659 N223SHAir Methods LLC · Greenwood Village, COS/N 7953 N224LALapd Air Support Division · Los Angeles, CABuilt 2022 · S/N 9185 N224MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9221 N225LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8628 N226LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8636 N226MTLendingclub Bank Na · Boston, MABuilt 2019 · S/N 8671 N227NDHillsborough County Sheriff · Tampa, FLBuilt 2022 · S/N 9296 N227TXTexas Department Of Public Safety · Austin, TXBuilt 2025 · S/N 9786 N229AHMiller Jason · Scottsdale, AZBuilt 2023 · S/N 9353 N229MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9203 N22TZKestrel Holdings LLC · Portland, ORBuilt 2014 · S/N 8016 N230AHAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9674 N230LALapd Air Support Division · Los Angeles, CABuilt 2020 · S/N 8794 N230TJAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7966 N231SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7993 N232LACity Of Los Angeles · Los Angeles, CABuilt 2023 · S/N 9298 N233LACity Of Los Angeles · Los Angeles, CABuilt 2024 · S/N 9428 N233PAComanche Maverick Air LLC · Houston, TXBuilt 2018 · S/N 8507 N234BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2012 · S/N 7398 N2374FTexas Department Of Public Safety · Austin, TXBuilt 2020 · S/N 8817 N237BSSky High Leasing LLC · Montrose, COBuilt 2013 · S/N 7542 N237SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 8005 N239AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2023 · S/N 9386 N239SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8100 N23HSVertical Corp · Kalispell, MTBuilt 2013 · S/N 7550 N240SHAir Methods LLC · Greenwood Village, COS/N 8105

Back to AD 2016-25-13