Skip to content

Registered aircraft · 120

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

N104VUAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0704 N105VUAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0724 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 N110VUAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0605 N120CRRomana Aircraft Inc · High Point, NCBuilt 2000 · S/N 1128 N122THMwn Holdings LLC · Saint Louis, MOBuilt 1998 · S/N 1017 N123RTMather Air LLC · Paris, KYBuilt 2004 · S/N 3841 N127ABApexheli Oregon Inc · Florence, ORBuilt 2000 · S/N 3331 N135CJAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0495 N135CPMh Hospital Manager LLC · Asheville, NCBuilt 2009 · S/N 0849 N135ECFight For Life Inc · Waukesha, WIBuilt 2009 · S/N 0862 N135LFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0647 N135MHBay Life Services Corp · Columbia, MDBuilt 2000 · S/N 0131 N136MFAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0384 N136VAAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0281 N138MHBay Life Services Corp · Columbia, MDBuilt 2005 · S/N 0417 N139MHMetro Aviation Inc · Shreveport, LABuilt 2004 · S/N 0330 N159AHVanderbilt University Medical Center · Nashville, TNBuilt 2023 · S/N 2224 N1601HValkyrie Europe LLC · Seattle, WABuilt 2013 · S/N 1134 N161WCWca Holdings V LLC · Missoula, MTBuilt 2012 · S/N 1064 N1FLRegistered aircraftBuilt 2022 · S/N 2168 N1VRegistered aircraftBuilt 2023 · S/N 2247 N200UPKmv Leasing LLC · Shreveport, LABuilt 1999 · S/N 0089 N2171CNs Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3427 N257BCMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 1043 N282CHMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0735 N28WSAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0502 N300HNAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 2292 N334HFHaynes Aviation LLC · Wetumpka, ALS/N 3676 N354PAPathfinder Leasing LLC · Anchorage, AKBuilt 2000 · S/N 3330 N356MPAltair Helicopter Service LLC · Marshfield, MABuilt 2000 · S/N 0163 N403AETemsco Helicopters Inc · Ketchikan, AKBuilt 2000 · S/N 3281 N405TJAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0405 N418MDMountain Air Helicopters Inc · Dover, DEBuilt 2004 · S/N 3848 N423CHAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 2331 N423NMNorth Memorial Health Care · Robbinsdale, MNBuilt 2022 · S/N 2193 N425NANational Aeronautics And Space Administration · Kennedy Space Ct, FLBuilt 2019 · S/N 2073 N435NANational Aeronautics And Space Administration · Kennedy Space Cent, FLBuilt 2019 · S/N 2081 N442MEMa Aviation Capital 1 LLC · Houston, TXBuilt 2011 · S/N 1042 N442NANational Aeronautics And Space Administration · Kennedy Space Ctr, FLBuilt 2020 · S/N 2127 N445MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2012 · S/N 1045 N448MELta Group Holdings LLC · Amarillo, TXBuilt 2012 · S/N 1048 N455AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 2328 N479LFGeisinger Medical Center · Danville, PABuilt 2025 · S/N 2314 N504LHAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0382 N511UWAir Med Services LLC · Lafayette, LABuilt 2006 · S/N 0511 N520MECtr For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2017 · S/N 2020 N523MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2025 · S/N 2323 N530MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2017 · S/N 2030 N533MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PABuilt 2020 · S/N 2133

Back to AD 2018-07-17