Skip to content

AD 2014-05-06 R1

Registered aircraft · 464

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

N911RZAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0834 N911SVSaint Vincents Healthcare · Billings, MTBuilt 2007 · S/N 0598 N911TBCook Children'S Health Enterprises · Fort Worth, TXBuilt 2009 · S/N 9281 N911TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2020 · S/N 9855 N911UGAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0416 N911UWMetro Aviation Inc · Shreveport, LABuilt 2021 · S/N 9864 N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132 N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154 N911XCMetro Aviation Inc · Shreveport, LABuilt 2000 · S/N 0143 N911XFAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0167 N911XGAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0157 N911XHAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0161 N911XJAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0763 N911XKAir Med Services LLC · Lafayette, LABuilt 2011 · S/N 0972 N911XMAir Med Services LLC · Lafayette, LABuilt 2013 · S/N 1105 N911XUAir Med Services LLC · Lafayette, LAS/N 0713 N911ZGGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2001 · S/N 0164 N912BFAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0344 N912CCAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9595 N912EFAir Methods LLC · Greenwood Village, COS/N 0421 N912UTMetro Aviation Inc · Shreveport, LABuilt 2009 · S/N 0858 N913ETEast Texas Air One LLC · Nashville, TNBuilt 2007 · S/N 0562 N914ETEast Texas Air One LLC · Nashville, TNBuilt 1997 · S/N 0018 N914THAir Methods LLC · Greenwood Village, COS/N 0440 N915ACAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0563 N915MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2010 · S/N 0910 N917ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0351 N917UTwiga Air LLC · Wilmington, DEBuilt 2007 · S/N 0550 N918ECPitt County Memorial Hospital Inc DBA · Greenville, NCBuilt 2007 · S/N 9121 N920AHMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0699 N920NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 0472 N922NHLta Group Holdings LLC · Amarillo, TXBuilt 2013 · S/N 1101 N925ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2023 · S/N 9882 N930NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 0461 N932MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2010 · S/N 0922 N933NHLta Group Holdings LLC · Amarillo, TXBuilt 2009 · S/N 0847 N935ACAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0346 N935MCMetro Aviation Inc · Shreveport, LAS/N 0485 N941TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2008 · S/N 0667 N944AMAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 9044 N944MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2010 · S/N 0945 N944NHBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 9181 N945MTMed-Trans Corp · Denton, TXBuilt 2021 · S/N 9871 N946MTMed-Trans Corp · Denton, TXBuilt 2021 · S/N 9872 N951TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2010 · S/N 0942 N952ALAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0627 N953ALAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0686 N954ALAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0694 N955ALAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0554 N955NHBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 9298

Back to AD 2014-05-06 R1