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.

N833CSReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 1052 N835CSMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1091 N835DHMary Hitchcock Memorial Hospital · Lebanon, NHBuilt 2016 · S/N 1245 N835TXPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0593 N836CSMed-Trans Corp · Denton, TXBuilt 2013 · S/N 1104 N836LFInhs Leasing Co LLC · Aurora, ORBuilt 2008 · S/N 0716 N837CSReach Air Medical Services LLC · Santa Rosa, CAS/N 1113 N838CSReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1123 N839CSReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1128 N840LFLife Flight Network LLC · Aurora, ORBuilt 2014 · S/N 1114 N845MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2009 · S/N 0845 N847LFLife Flight Network LLC · Aurora, ORBuilt 2007 · S/N 0534 N84UCUc Health LLC · Cincinnati, OHBuilt 2022 · S/N 9873 N850UWMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9837 N854ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2010 · S/N 9327 N855MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2015 · S/N 1205 N863NCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0564 N864NCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0567 N865NCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0584 N874BUMetro Aviation Inc · Shreveport, LABuilt 2022 · S/N 9874 N877CRAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0625 N87MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2013 · S/N 9603 N883AEAir Evac Ems Inc · O Fallon, MOBuilt 2008 · S/N 0749 N884AEAir Evac Ems Inc · O'Fallon, MOBuilt 2012 · S/N 1059 N884MELta Group Holdings LLC · Amarillo, TXBuilt 2010 · S/N 0884 N885AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 1213 N885ALMetro Aviation Inc · Shreveport, LABuilt 2007 · S/N 0591 N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051 N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052 N893AUMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9862 N893HFHealth First Shared Services Inc · Rockledge, FLBuilt 2010 · S/N 0893 N903SHSanford North · Sioux Falls, SDBuilt 2012 · S/N 9432 N904VUVanderbilt University Medical Center · Nashville, TNBuilt 2005 · S/N 0418 N905VUVanderbilt University Medical Center · Nashville, TNBuilt 2011 · S/N 0994 N906GLGundersen Lutheran Medical Center Inc · La Crosse, WIS/N 9089 N906SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9479 N906VUVanderbilt University Medical Center · Nashville, TNBuilt 2009 · S/N 0788 N908ACAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0412 N908SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9482 N909SHSanford Health · Sioux Falls, SDBuilt 2010 · S/N 9359 N910NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 9084 N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021 N911BHAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 9545 N911CKEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 0138 N911EFAir Methods LLC · Greenwood Village, COS/N 0497 N911ERAir Med Services LLC · Lafayette, LABuilt 2009 · S/N 0764 N911ETEast Texas Air One LLC · Nashville, TNBuilt 2007 · S/N 0541 N911KBMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0095 N911KSMed-Trans Corp · Denton, TXBuilt 2011 · S/N 1012 N911MKAvera Mckennan · Sioux Falls, SDBuilt 2008 · S/N 9218

Back to AD 2014-05-06 R1