Skip to content

Registered aircraft · 670

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:2025-04-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2025-04-10') 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:2025-04-10')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2025-04-10')
  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:2025-04-10')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2025-04-10')
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 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 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 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 N119MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1197 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 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 N135EDAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0335 N135GFMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0249 N135HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2020 · S/N 9847 N135LCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0296 N135LFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0647 N135LLMercy Hospital Springfield · Springfield, MOBuilt 2006 · S/N 0491 N135LXMed-Trans Corp · Denton, TXBuilt 2011 · S/N 1004 N135MFZmog Management Company LLC · Folsom, CABuilt 2007 · S/N 0623 N135MHBay Life Services Corp · Columbia, MDBuilt 2000 · S/N 0131

Back to AD 2025-04-10