Skip to content

Registered aircraft · 947

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

N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N103VUAir Methods LLC · Greenwood Village, COS/N 9054 N104AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2021 · S/N 21016 N104VUAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0704 N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N105VUAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0724 N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109AZWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 22223 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 N109DRBristow LLC · Lake Charles, LAS/N 31311 N109SPDouble Or Nothing LLC · Prosper, TXBuilt 2012 · S/N 22291 N110AWRegistered aircraftBuilt 2022 · S/N 21158 N110GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 21444 N110SLAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9302 N110VUAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0605 N112AHUS Army · Redstone Arsenal, ALBuilt 2014 · S/N 9684 N112MTReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1129 N113AHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 9858 N113GRReach Air Medical Services LLC · Lewisville, TXBuilt 2025 · S/N 21403 N113MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1103 N116MWNextera Energy Equipment Leasing LLC · West Palm Beach, FLBuilt 2017 · S/N 69042 N116TGLeonardo Helicopters US Corp · Philadelphia, PAS/N 41630 N117GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 2326 N117SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0369 N118JMMjm Aviation LLC · Piscataway, NJBuilt 2010 · S/N 41251 N119MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1197 N119MWBristow LLC · Lake Charles, LABuilt 2012 · S/N 41307 N11ZPRegistered aircraftBuilt 2024 · S/N 21270 N122GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2340 N125TTCorpat Inc · Missoula, MTS/N 21329 N127AHAirbus Helicopters Inc · Grand Prairie, TXS/N 21536 N127JLBristow LLC · Lake Charles, LABuilt 2011 · S/N 0976 N12MQArrow Aviation Company LLC · Broussard, LAS/N 31041 N131HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2020 · S/N 9861 N131LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2006 · S/N 9096 N131SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0373 N132HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2009 · S/N 0839 N134AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0324 N135AEDodson International Parts Inc · Rantoul, KSS/N 1127 N135BREurotec Vertical Flight Solutions LLC · Eudora, KSS/N 0218 N135BUMetro Aviation Inc · Shreveport, LABuilt 1997 · S/N 0015 N135CJAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0495 N135CMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0706 N135CPMh Hospital Manager LLC · Asheville, NCBuilt 2009 · S/N 0849 N135DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0133 N135ECFight For Life Inc · Waukesha, WIBuilt 2009 · S/N 0862

Back to AD 2026-17-05