Skip to content

Registered aircraft · 270

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:2021-24-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:2021-24-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:2021-24-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:2021-24-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:2021-24-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:2021-24-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 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N112MTReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1129 N113MTMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1103 N117GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 2326 N119MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1197 N122GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2340 N127JLBristow LLC · Lake Charles, LABuilt 2011 · S/N 0976 N132HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2009 · S/N 0839 N135AEDodson International Parts Inc · Rantoul, KSS/N 1127 N135CMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0706 N135GFMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0249 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 N135MLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 0940 N135NKAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0480 N135UTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0776 N135VVMed Trans Corp · Denton, TXBuilt 2011 · S/N 1019 N135WLMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1083 N136UTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0841 N138HNAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0288 N138LNAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0352 N139HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2293 N139TJAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0322 N143MHMetro Aviation Inc · Shreveport, LABuilt 2007 · S/N 0613 N159AHVanderbilt University Medical Center · Nashville, TNBuilt 2023 · S/N 2224 N159MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 1199 N1601HValkyrie Europe LLC · Seattle, WABuilt 2013 · S/N 1134 N162AECharlotte-Mecklenburg Hospital Authority · Charlotte, NCBuilt 2013 · S/N 1125 N163BFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0671 N166MTMed-Trans Corp · Denton, TXS/N 1167 N1FLRegistered aircraftBuilt 2022 · S/N 2168 N1VRegistered aircraftBuilt 2023 · S/N 2247 N2066FTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 2066 N222HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2289 N223WLMed-Trans Corp · Denton, TXBuilt 2024 · S/N 2286 N224VVMed-Trans Corporation · Denton, TXBuilt 2025 · S/N 2299 N225LXMed Trans Corp · Denton, TXBuilt 2025 · S/N 2313 N226SABennett Aviation LLC · Elmhurst, ILBuilt 2007 · S/N 0559 N228BJBristow LLC · Lake Charles, LABuilt 2011 · S/N 0982 N228MTAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 0908 N230AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0540 N235LLMercy Hospital Springfield · Springfield, MOBuilt 2008 · S/N 0662 N240HYAspirus Wausau Hospital Inc DBA · Wausau, WIBuilt 2022 · S/N 2170 N244AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0610 N252SABennett Aviation LLC · Elmhurst, ILBuilt 2008 · S/N 0707 N253AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0663 N253MTMed-Trans Corp · Denton, TXBuilt 2014 · S/N 1153 N253SABennett Aviation LLC · Elmhurst, ILBuilt 2010 · S/N 0890

Back to AD 2021-24-05