Skip to content

Registered aircraft · 345

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-01') 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-01') 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-01')
    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-01')
  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-01')
  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-01')
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 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 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 N117SHAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 0369 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 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 N135DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0133 N135EDAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0335 N135GFMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0249 N135LCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0296 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 N135MLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 0940 N135NMh Hospital Manager LLC · Asheville, NCBuilt 1998 · S/N 0086 N135NKAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0480 N135TGAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0298 N135TJAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0329 N135UTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0776 N135VVMed Trans Corp · Denton, TXBuilt 2011 · S/N 1019 N135WJAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0287 N135WLMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1083 N136KYAir Methods LLC · Greenwood Village, COS/N 0494 N136MFAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0384 N136UTMed-Trans Corp · Denton, TXBuilt 2009 · S/N 0841 N136VAAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0281 N137AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0326 N137MHMetro Aviation Inc · Shreveport, LABuilt 2002 · S/N 0179 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 N139MHMetro Aviation Inc · Shreveport, LABuilt 2004 · S/N 0330 N139TJAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0322 N143MHMetro Aviation Inc · Shreveport, LABuilt 2007 · S/N 0613 N158BCMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0134 N159AHVanderbilt University Medical Center · Nashville, TNBuilt 2023 · S/N 2224

Back to AD 2018-07-01